-
Formula(s) to select & show project status
For each project sheet, I show the total number of tasks over due (red), due within 7 days (yellow) and not yet due (green). Now I want to create an executive report that shows a red, yellow, or green light for each sheet based on the category that has the highest number of tasks. Ultimately, the executives will receive a…
-
RGYB Ball Color not showing on report intermittently
I have a report that pulls a summary row from various smartsheets. I have a column in these sheets titled Progress Indicator. I have a nested IF statement to show the correct ball color. I just noticed that some of the sheets are pulling in the actual ball symbol and some are giving me the text name of the color. When I go…
-
Augmenting SmartSheet
Hi there SmartSheet Community, We are using an existing system for job management and for accounting, and have introduced SmartSheet for the management of project plans. In order to meet the requirement for consolidated reporting of project financials and capacity, we have carried out a deal of augmentation around…
-
Turning "=year" value into 2 digit number and "=yearday" value into 3 digit number.
Hi there, With "=year()" function, I can get the year in 4 digit numbers and with "=yearday()" formula, I can get the day in 1 to 3 digit numbers. However, I am trying to combine them into 5 digit number ("YY" + "DDD") to automatically generate julian date. Since Smartsheet doesn't have the "=text()" function, I am not so…
-
Hiding Formulas
Hi, I am designing solutions for several clients on Smartsheet. Is there a way to hide the formula so it doesn't display when you "mouse over" it? I don't want the clients to see "my magic" - very easy for them to copy it and do it themselves... Thx Werner
-
Extract Column Name using a Formula
Hi, I'd like to be able to extract column names using a formula and use them as row headers. Is this possible?
-
Using RAGB plus adding Blank Cell action
I am trying to use the RAGB indicators to look at if a Due date is set and then setting the Indicator to Red if in the past, Yellow if in the next 3 days and Green if in the future beyond 3 days. We are also using the Blue to indicate if the task is complete. This works fine with the following formula, however for blank…
-
combining formula to round a sum
I'd like to know if I can combine the two following formulas in some way so that I only need one column: In the first below, I'm calculating the average number of minutes an editor spends on each page of a document. But, because I don't want to report the number with such precision, I have a second column with a formula to…
-
Date Formula to exclude weekends
Hi Friends, I need a formula that would result in a Date = Today + 1 day, but if Date is on a Saturday or Sunday, Date should be the following Monday. I also need the same for Date = Today + 3 days but the calculated Date should add 3 week days (Mon - Fri) and not be a Saterday or Sunday. Hope this make sense?
-
New Filtering and Filter sets
Hi All, I appreciate the new Filtering functionality to make and share filter sets with users, great idea. I have a refinement to suggest. Can I ask to have a filter condition included to equate the value to a maximum or minimum value of the field? is same as Maximum is same as Minimum This way when a maximum or minimum…
