-
IF formatting combined with a calculation
I am trying to include a calculation only if a certain qualitative value is met. Trying to have the column indicate "Days Over Deadline" by subtracting the "Submission Deadline from the Submission Date," but only if the "Assessment Stage" is Issued. =IF([Assessment Stage]@row)="Issued", =SUM([Submission Date]@row) -…
-
NEED A WAY TO REFRESH ALL SOURCE SHEETS AT ONCE!!!
Having to open each source sheet to have the conditional formatting update is not efficient. The refresh on reports and dashboards do not update the conditional formatting for each row. Every single sheet must be opened every day for them to display the correct colors (ex: 3 days away - blue, 1 day away - purple). I log on…
-
Need assistance with formula
I have this formula on a column =IF(Status@row = "Complete", "100%", ="In Progress", " %"), I want the user to be able to add in a number when the status@row is "in Progress". How can I write the formula to be able to allow the user to type in a progress level. "In progress" may be 75% or 50%
-
Make conditional formatting refresh all source pages for report and dashboard accuracy
Reports and Dashboards do not currently update the colors of conditional formatting. For instance, I have it set to change the color when it's 3 days away. Unless I open the source sheet, the reports in dashboards will not update. Even if I press the refresh button on the report or the dashboard, it doesn't actually…
-
Change drop-down option in one cell based on data entered in a different cell
I am looking for a way to automatically select a drop-down option in one cell based on the data entered into a different cell. Monthly we track target goals against actual goals. The target goals stay the same throughout the year, however the actual goals are updated monthly. Based on the actual goals, monthy we determine…
-
I am not able to access the conditional formatting button?
Hello! I have been using conditional formatting for my calendar view, but when I went to try today, I couldn't find it anymore! Did smartsheet change the formatting? How can I get to the conditional formatting setting?
-
Problems with conditional formatting on my sheet when it's not listed as a condition
I'm having the weirdest problem on one of my sheets. Below are the only conditions on my sheet, but adding a new task or row applies the pastel yellow to the row. In another cell it's applying a navy background. In the same column it bolds all the text and turns the font color white. None of these appear to be conditions…
-
Can I conditionally format a cell if it contains text from a range consisting of multiple rows?
I have a column containing text (multiselect drop down) that I would like to eventually conditionally format based on the presence of matching text from cells in a range made of multiple rows. Here is fictitious data in an excel format for simplicity. Sheet 1 Range 1 (Column C) contains the data I want to format based on…
-
Need help creating formula to show # of Children that are complete & percentage
Should display something like: 2/10 (20%) # completed tasks / total tasks (percentage of total) Can you please help?
-
Reminder workflow for past due approval
I'm essentially a nube to Smartsheet (so be gentle please), though I've come up the learning curve some distance. I've drafted an app to track a form thru the approval process. I'm at the stage where I'm trying to add bells-n-whistles to the app. That includes a reminder workflow to approvers who have not responded to the…
