Is there a formula where I can create the following from entering the #3 on row 1?

KarinM

KarinM ✭

02/26/24 in Formulas and Functions

0 ·

Answers

Julie Fortney Overachievers

03/05/24

@KarinM Could you provide a bit more detail about your request?

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

Weird Formula Help
I have the following columns in my sheet: Is This An Object? (a drop down "Yes" or "No" column) Object # Box # Folder # HW ID I need a formula for the HW ID column that mirrors the "Object #" IF the "Is This An Object?" cell is "Yes". However, IF the "Is This An Object?" cell is "No", then I want the HW ID column to…
Vlookup - #unparseable result
I built a tracker that is populated with an intake form. One of the criteria is a broker code, that when entered on the tracker from the form, is vlookup’d from a reference sheet and gives me the broker’s name, their branch code and branch name. This works perfectly fine for our purpose. Our team has now been tasked with…
Milestone Report
How do I get this calendar on the right no to show? I'm using a report to pull this info This is what my report looks like