Sign in to join the conversation:
I am getting an error with this formula:
=MAX([Due Date]:[Due Date])
#Invalid Column Value....the column name is Due Date and the data is configured to take Date..
Thanks
Hi Gwen,
Make sure that the column with the formula is formatted as a date column type.
Did it work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" to…
I’m trying to set up an automation rule in Smartsheet where the “Status” column automatically changes to “In Progress” when the “% Complete” column is updated to a value between 1% and 99%. I noticed that there isn’t a “between” function available when setting conditions in the automation workflow. What is the correct way…
Hi all, I need support by set up of a formula. The case is: - If column 'Team' = Security AND column 'T-shirt size hours' = L = 2 days THAN column Days_Sec = 2 - If column 'Team' = Development AND column 'T-shirt size hours' = L = 2 days THAN column Days_DEV = 2 - If column 'Team' = Basis AND column 'T-shirt size hours' =…
