-
Formula or Rules to AutoPopulate Columns in Sheet
I have a master data sheet where a team of 30+ people will be adding 2021 data and creating our annual plan. To make it easier for them to complete the sheet, I wanted to have the ability to autopopulate certain columns based on their answer from a drop down choice in an earlier column. As an example: 1) If they select…
-
Looking to create a formula to count number of tasks
On the "Corporate Legal" row the formula in the "0 of 8" is the following: =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) I want to create a Parent Count for all tasks. There are other sections with the same setup. I want the parent section (the cell with a blue border) to count all number of tasks. So if I have "0…
-
How do I use @row in an IF formula when I am referencing many columns for 1 response?
I created a plan with 8 goals, each goal has their own objectives (range from 3-11 objectives each goal, and each objective has their own strategies (range from 3-12 strategies each objective). I want to reference any one of the 42 columns I created for the form logic so drop downs would reflect in the objective or…
-
How to have a formula reference a blank report?
(FYI I do not have summary sheet access) I have a sheet that has a list of open Job opportunities. Of course sometimes that sheet is blank because there are no openings. I created a second sheet for metrics that I could use to put a counter-widget in my dashboard. That is, in my dashboard there would be a metric widget…
-
How to change my status column when Completed column is not blank
Hi everyone - I am new to smartsheet and am trying to figure out a formula for the following scenario: When Completed Date is not blank, make status Complete, otherwise I want to leave whatever value is there (the value will either be In Progress or On Hold). Help greatly appreciated.
-
RGB Formula
I am wanting my formula to turn yellow if the end date is between 3 and days away. How would I make that work? IF(AND(Status@row = "In Progress", [End Date]@row > TODAY(-10), [End Date]@row < =TODAY(3))
-
Count IFS
I am trying to build a formula that will count the number first based one the COE name, then to give a number on each disposition status. I thought it would be something like: =COUNTIF({Policy Project Status Report Range 3}, "Global Rewards"),({Policy Project Status Report Range 1}, "Keep/Enterprise") OR…
-
Gantt Chart bars - different colors to distinguish
Hi all, Is there a way to change the color on a gantt chart view while utilizing it on a dashboard? I tried to change them from the report but I can't seem to find the option. Maybe I'm thinking that I've used it under the calendar functionality and getting confused. Can someone confirm?
-
Integration + Feature Request: Google Sheets with Smartsheet Tabs
I know this is probably a longshot, but it'd be really awesome if Google Sheets would enable us to have both Google Sheet tabs and Smartsheet tabs (with Gantt chart capabilities fully enabled). Right now we can transfer the data but none of Smartsheet's Gantt chart functionalities are transferred.
-
IF Function Condition - UNPARSEABLE
Hello, I have the following formula that does not seem to be working. =IF([Result]19<0,100%,IF((AND([Result]19>=100%,[Result]19<103%)),100%,IF((AND([Result]19>=103%,[Result]19<106%)),75%,IF((AND([Result]19>=106%,[Result]19<109%)),50%,IF((AND([Result]19>=109%,[Result]19<112%)),25%,IF([Result]19>=112%,0%,0)))))) For every 3%…