Can you use a formula such as IF that would allow me to manually input a number in the field?


My formula is =IF(PROPOSAL@row = "NO", "N/A", IF(PROPOSAL@row = "YES" ... this is where I would like to leave the field blank for a manual input. If that's not an option, if "YES" what would I use to point to another column to bring in the quote number as this is not working: =IF(PROPOSAL@row = "NO", "N/A", IF(PROPOSAL@row = "YES", MATCH([QUOTE #]@row)))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!