How do I have the Status column automatically say "submitted" when a user fills out the form?

Dana Lopez

Dana Lopez ✭✭✭

10/07/20 in Formulas and Functions

Currently it comes in empty, but I want it to say submitted.

0 ·

Best Answer

RossL ✭✭✭✭✭✭

10/07/20 edited 10/07/20 Answer ✓

@Dana Lopez In the form builder you can set the default value for the Status column to "Submitted" and then Hide it on the form.

5 · Share on Facebook Share on Twitter

Answers

RossL ✭✭✭✭✭✭

10/07/20 edited 10/07/20 Answer ✓

@Dana Lopez In the form builder you can set the default value for the Status column to "Submitted" and then Hide it on the form.

5 · Share on Facebook Share on Twitter
Dana Lopez ✭✭✭

10/07/20

Thank you so much!

0 · 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

Multiple Criteria Formula - Metric Sheet
I am looking for a formula to calculate the number of APPROVED projects with Technology Impact. I am able to get the number of all projects with technology impact, but cannot figure out the second part of the formula to only include APPROVED projects. Current formula which includes information from the Technology Impacted…
Data reference from one sheet to another Formula not working
Hello community, I was trying to reference some data from one sheet to another via formula but it doesn't seem to work error in cell: " #unparseable" , here a breakdown of my goal and the formula I am trying to use: have 2 separate sheets, in the main one named request for information where people will submit their request…
Basic Cross Sheet Reference Not Working
I am trying to create a very simple formula to count the number of rows in a sheet based on status type. I'm getting an "unparseable" error and I can't figure out why. I've tried both the below criteria and "Intake" and am receiving the same result. Any ideas on what might be broken here??