Trying to get a percentage from value and total value. Formula below is not working

ops

ops ✭✭

03/19/25 edited 03/19/25 in Formulas and Functions

0 ·

Answers

Isis Taylor ✭✭✭✭✭✭

03/19/25

@ops I used the same formula and the correct value was returned. Are you receiving an error message?

Isis Taylor
🎓️ Core App and Project Management Certified 🏅
🌟Peer Connect, Mobilizer, and Early Adopter Program
Business Analyst Senior
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

Formula Help! Adding Values in child rows based on date range
I'm trying to add the values entered in all child rows in a column, based on the date range (by quarter): =SUMIFS(CHILDREN([PT Total Hours]@row ), CHILDREN(Date@row ), ">=01/01/2025", CHILDREN(Date@row ), "<=03/31/2025") This is what the AI formula came back with, also what another external AI platform came back with.…
CountIFS contact is in a contact list
=COUNTIFS({TEST Range 1}, ="*Name*", {TEST Range 6}, ="DO") Hi all, this is a helper sheet used to get the counts of different conditions. Test Range 1 is a contact list that can contain multiple contacts, how can i make it so that i can check if "Name" is in the list. It is currently returning 0 when it should be finding…
Character Limit Formula
I'm unable to convert this to column formula (probably due to the reference to my 'blank' column… However, this formula doesn't work, =IF(LEN([Source Admission ID]) >= 21, "Source Admission ID Limited to 20 VARCHAR", "") So, I changed it to this, which works… =IF(LEN([Source Admission ID]) >= 21, "Source Admission ID…