Percentage formula
I am trying to get a percentage of admin from the total hrs logged in the individual utilization collumn using this formula but it is not working. =IFERROR(Admin@row / [Total Hrs Logged in]@row, "") please help.
Answers
-
I figured it out so thank you I had some column properties incorrect "Allow Multiple Values per Cell" on which caused the issue.
-
What type of column are your Admin/Total Hrs Logged in columns?
It looks like they are dropdowns with multiple options allowed selected - if you remove the multiple options then your formula should work.
Alternatively this can jump to doing the percentage directly without making any changes - assuming your columns are only having one option selected:
=IFERROR(VALUE(LEFT(Admin@row, LEN(Admin@row))) / VALUE(LEFT([Total Hrs Logged In]@row, LEN([Total Hrs Logged In]@row))), " ")
Hope this helps; post if you have any problems/queries though.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives