Hi,
I've read through a few threads and I am unable to re-create a simple countdown formula. I keep getting an #INVALID OPERATION error.
Am I missing something? Please help! Thank you!
Are both the Target Date and Today formatted as Date column types?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Yes, both columns are Date types.
That's strange!
It should work.
Try to change the columns to text and back again and also try to edit the formula and then change it back again. Maybe it's a glitch.
Did it work?
Yes!! That fixed it!! I seriously thought I was going crazy!
Thank you so much for your suggestion, I knew it had to be something simple!
Excellent!
Happy to help!
(I starred at it for a long time as well)
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
