Auto update Date field when a document is attached

JCrawford

JCrawford ✭✭✭

08/03/24 in Formulas and Functions

I am looking for a formula that automatically updates the 'Status' field to Complete when a document is attached to a row. Is this possible?

0 ·

Best Answer

JCrawford ✭✭✭

08/03/24 Answer ✓

Problem solved! I realized that I could set up a workflow that will update the 'Status' to complete when an attachment is added.

1 · Share on Facebook Share on Twitter

Answers

JCrawford ✭✭✭

08/03/24 Answer ✓

Problem solved! I realized that I could set up a workflow that will update the 'Status' to complete when an attachment is added.

1 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Subtract 1 month from the date expire for a task
I have a column that calculates a due date that uses this simple formula: =DATE(YEAR([Date Expired]@row), MONTH([Date Expired]@row) - 1, DAY([Date Expired]@row)) It works great but for some reason returns #INVALID VALUE when the date expired is any day in January. any other month seems to be fine I'm guessing because the…
Count(Distinct(Collect Help
Hi All, I'm trying to count the number of 'distinct' participant to events based on the year and add that count to their org leaders. In the table where I have the participant I've alredy added helper columns to identify their leaders at different lvl. My formula works fine as long as I point to the specific column where I…
Formula for Index/Match Multiple Criteria
Can someone help me with an Index/Match or Index/Collect formula to accomplish the following logic? When {ArchiveCSYYXXXX} = CSYYXXXX@row AND {Task} = "Final Signed", provide {FinalSignedDate} In case it's relevant {ArchiveCSYYXXXX} and {Task} are child rows on their sheet. Thanks so much in advance!