-
Percent Complete by Cell Color
Is there a formula to determine percent complete of a task based on the cell color? Cells are filled with dates of various steps in a project and once those are completed, the cell is highlighted. I'd like to have the percent complete column update automatically when the cell color is changed. Help, please!
-
Autofill Capabilities based off of Dropdown selections?
When selecting from a dropdown menu, can you build corresponding autofill capabilities into the next cell? I have a dropdown list of classifications that correspond to a weighting system. I'd like to be able to select a specific classification and have the following weight cell autopopulate. Is that possible through a…
-
Custom formatting - individual cells
Excel has the functionality to define custom formats by cell - for example, you can say that for each cell in a range, if the cell value is negative, then the font colour will be red, otherwise it will be black. Does smartsheet have this functionality? So far I can only see fuctionality to format an entire row based on a…
-
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…