Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Circulatory Reference - checking if ISBLANK
I need to check if a cell is blank and if it is blank I need to populate it with data from another cell.
When I say
=IF(ISBLANK([current cell]1), today())
It references it's own cell.
Any suggestions?
Comments
-
Hi Joyce,
As you've found, there isn't a way for a formula to reference its own cell, this leads to a circular reference and logic issues with the formula.
Can you provide more information on why you need a function to see if its own cell is blank and return the current date?
-
Hi, I have same question. If cell is blank I would like the cell becomes blue and would like it becomes populated with expression "Low - by default" . Thank you. Why circular reference is in place? This condition also exist in excel with no issues. Thank you
-
Hi Brano,
Great idea! That would be a great addition to Smartsheet features.
Please submit an Enhancement Request when you have a moment.
A possible workaround could be to use a third-party service like Zapier to change it automatically and then conditional formatting to change the color.
Would that work?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives