Sign in to join the conversation:
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)
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
