-
Keeping track of old baselines
Hi I want to know if there is a simple way of keeping a log of baselines, e.g. each time it is reset, the old baseline is logged, similar to version control. The idea is that at the end of a project (which underwent change control resulting in the timeline needing to be re-baselined) we will be able to review the changes…
-
Average + Harvey balls
I'am new in smartsheet and I want to find the average score of my team in different areas using the harvey balls, and have the results measured via the spheres, I was trying to use the average function + harvey line but it gives me as a result error, thank you for your help
-
Text in 'Contact List' variable
Hi all, I would like to bring forward a new idea. I have an 'assigned to' column with a 'contact list' variable. In the settings, I allow to also just enter text of names (for example for people not having a SS account) - as in the settings I did not select 'Restrict to list values only' (see screenshot below). It is all…
-
Help with Trend Data
I need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. Ex: How many projects are Red, Yellow and Green. This works really well for live data.…
-
Multi-Condition Logic
I would love to see the ability to have multiple conditional factors in the logic system in smartsheet forms. I.E. When ABC = XYZ & When DEF = UVW Then Show Fields 3,4,5
-
Is there a way to adjust font size and formatting on a report widget in my dashboard?
I have a report widget in my dashboard and have increased the font size on the source sheet but this is not reflected in my widget. is there a way to manually do this?
-
Percentage formula does not work if denominator is zero
Hi, I have the formula for percentage but when denominator is zero, instead of showing 0%, it does not show anything. How can I make it such that it returns zero if that is appropriate so that my run chart does not look like its missing data points? Thank you!
-
Dashboard
Is it possible to create a report from a set of mulitple reports , I want to create a master dashboard from a set of individual dashboards
-
If(And( formula isn't returning correct colors
My goal is: if NCLEX is greater than 95% = Green If NCLEX is between 85%-94.99% = Blue If NCLEX is between 75-84.99 = Yellow If NCLEX is less than 74.99 = Red Below is the formula I am using and it is only returning Red =IF([NCLEX Passing Rate]@row > 95, "Green", IF(AND([NCLEX Passing Rate]@row > 85, [NCLEX Passing…
-
Text in 'Contact List' variable
Hi all, I would like to ask a stupid question. I have an 'assigned to' column with a 'contact list' variable. In the settings, I allow to also just enter text of names (for example for people not having a SS account) - as in the settings I did not select 'Restrict to list values only' (see screenshot below). It is all…