I would like that the date and time is registered when a button was pressed, but I want it in different columns based on a dropdown list (select list column). E.g. If in the select list (Status) the value is “Selected” I want that the date and time of the button press is displayed on the column cal…

Yeah, the switchif() returns a date and not the whole column, that’s why it fails. Try this instead: Switch( thisRow.Status, Selected,thisRow.ModifyRows(thisRow.[Selection date],Now()), Confirmed,thisRow.ModifyRows(thisRow.[Confirmation date],Now()), Completed,thisRow.ModifyRows(thisRow.[C…

[image] Tamas_Mahner: ModifyRows(thisRow,switchif(thisRow.Status=Selected,thisRow.[Selection date],thisRow.Status=Confirmed,thisRow.[Confirmation date],thisRow.Status=Completed,thisRow.[Completion date],Now())) Hi @Tamas_Mahner , I didn’t take a look at your doc, just formatted your formula w…

Hello Pablo! Indeed that was a syntax mistake, but even after fixing it, the error message is still the same: [image]

Wooooooooow!!! Thanks a lot! It even works with RunActions in the more complex formula! You made my day, thanks a lot!

The only thing that I have to be cautious is that in case I change the select list items, I will have to be aware to change it also in the Switch formula, value part. I cannot link it so it changes if I change in the select list.

Yep, coupled code sucks This could be an intersting read for you [image] New formulas for columns Suggestion Box Goal Dynamically select a column from a table Issue The current possible approach forces you to repeat yourself into a coupled mess: Select Op…

The more I work with Coda the more things I discover wanting to have which is not yet available. :smiley:

[image] Tamas_Mahner: The only thing that I have to be cautious is that in case I change the select list items, I will have to be aware to change it also in the Switch formula, value part. I cannot link it so it changes if I change in the select list. That should not be the case, as you can s…

Dear Pablo, Again thank you very much for your support! At the end I created a table instead of a select list and in this way I managed to create the “chips” instead of the strings. But it’s good to know it is possible with the select list too! All working perfectly now!

Modifyrows - selecting the column value with SwitchIf formula?

Superhuman Ask the Community

Rickard_Abraham April 24, 2025, 12:40pm 7

Yep, coupled code sucks

This could be an intersting read for you

Topic		Replies	Views
Formula is pulling everything in from the column instead of specific row Ask the Community	3	260	January 29, 2024
Switch to output value from another select list table Ask the Community	4	167	March 4, 2025
Switch statement to return tables Ask the Community	4	947	September 11, 2022
Button and Look Up interaction Ask the Community	12	1026	September 6, 2022
If name & date match -> change value Ask the Community	11	848	July 8, 2021

Modifyrows - selecting the column value with SwitchIf formula?

Related topics