Could someone help provide steps on how we would get a WORD TRIGGER to appear if the value is over 4% or under 4%?
You can use an IF function to evaluate if the value in the column with your percentages in is over 4% and have this return different text depending on whether this is true or false. Percentages are stored in smartsheet as decimals if the column format is percent so your formula would be
=IF([column with %]@row > 0.04, "OVER 4%", "UNDER 4%")
If you prefer to include any that are exactly 4% as being over 4% then you can use >= instead of >
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.