Automation to change a date - column not coming up
I am setting up a workflow that once a checkbox is selected it inserts the date in a date column. But the column isn't showing as a date column. Any ideas why this might be? Attached is a screenshot of the column properties.
Best Answer
-
@B Young It's not an option because of the column formula. if it's just a regular cell formula it will overwrite but not a column formula.
Answers
-
@B Young and you are using the record a date workflow?
-
Yes I am - see the screenshot for the workflow. Does it look correct?
-
@B Young and to galv trusses isn't a drop down option? to galv trusses does not have a column formula set, does it?
-
No it isn't an option and yes it does have a column formula in it.
What is strange is I had tried it all on a 'testing' sheet that I have before putting it on our 'live' sheet and it worked fine on the testing sheet. They both have formulas, are used in conditional formatting, are locked columns. There must be something wrong, but I just can't figure it out yet!
-
@B Young It's not an option because of the column formula. if it's just a regular cell formula it will overwrite but not a column formula.
-
Ok thank you for your reply
-
@B Young no problem If you need it to be a column formula, then use a helper column that isn't a column formula and in your column formula use an if statement to look at the helper column to see if it has a date in it. Something like that, if that makes sense.
-
Yes that does make sense and is a helpful suggestion. Can't wait until SmartSheet can do something more with the column formulas - they are great but I find them a bit restrictive still!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives