Automation to change a date - column not coming up

B Young

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.

To Galv Trusses.png

Samuel Mueller

@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.

Samuel Mueller

@B Young and you are using the record a date workflow?

B Young

Yes I am - see the screenshot for the workflow. Does it look correct?

Workflow.png

Samuel Mueller

@B Young and to galv trusses isn't a drop down option? to galv trusses does not have a column formula set, does it?

B Young

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!

Samuel Mueller

@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.

B Young

Ok thank you for your reply

Samuel Mueller

@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.

B Young

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!