Formulas and Calculations

dennis.goudy72296

dennis.goudy72296 ✭✭✭✭

04/24/19 edited 12/09/19 in Formulas and Functions

Duh!! I figured it out. It was simple.

Dennis

Tags:

0 ·

Comments

Andrée Starå Community Champion

04/25/19

Hi Dennis,

Excellent!

Glad to hear that you got it working!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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

Is there a way to make a field in a form auto populate street address as its being entered?
I have a shipping management Smartsheet that has a intake form with a address field. When users fill in the address field sometimes they do not provide the entire address. I want the address to auto populate as they type in their address.
IF formula for INDEX/MATCH across sheets
Hi, I'm really struggling with this one. I have a sheet that has a drop-down with options for "Yes" and "No" and I want to perform an INDEX/MATCH function based on another cell in that row, but only if the result of the drop-down in that row is Yes. The sheet reference for the Yes/No drop down is {App_S}, and the two cells…
NETDAYS Formula Question
I have created a formula to track in progress orders by the number of days, =NETDAYS([Date Received]@row, TODAY()) I have the following columns created, Date Received, Date Completed, In Progress Days This is a formula attached to the entire column, but I need cells for orders completed to stop counting as in progress. Is…