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.
I figured it out so thank you I had some column properties incorrect "Allow Multiple Values per Cell" on which caused the issue.
Hi @Weston Johnson
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.
I am running VLOOKUP to bring a picture located in a specific row cell over a new sheet cell. The issue is that picture comes as a text (picture name). My ultimate goal is to pull that picture into a dashboard, when trying that, just the text comes If I bring picture directly from the smart sheet where picture is located…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
I have a report that is filtered by a particular folder within a shared workspace... everytime I remove items from that folder the report no longer watches the folder, and it turns into individual items within the folder... Is this common behavior? Has anyone else experienced this behavior recently? I want the subfolder to…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.