-
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?
-
Alerts not working
Hi All, I have a very simple smartsheet and if I add Yes in a drop down to a field (Output for Personnel File) then I want an alert sent. I have made settings unrestricted although the alert is to me and I am the owner. I have ensured that I save the data but nothing is triggered However, if instead of an ALERT someone…
-
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.
-
Using FIND within a COUNTIFS formula and a Multi-Select Column
Hello, New to Smartsheet.gov and I'm having an issue. My data sheet has a column with events attended. It's a multi-select dropdown. Each participant is tagged with the events they have attended. I have a tally sheet by country to count how many participants have attended each event. The formula below is pulling correct…
-
Formula Help: Combining Checking a Box with a % Complete to Return a Status Ball
I'm having a hard time combining a formula that when I check off the "Done" checkbox it turns the % Complete to %100 and also changes the health to green as well as combining the criteria of this formula: =IF([% Complete]12 < 0.5, "Red", IF([% Complete]12 < 1, "Yellow", "Green")) Is this possible?
-
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…
-
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…
-
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))
-
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%…
-
VLOOKUP with Duplicate Data
I have a master sheet that may have duplicated column data, like: Client Name | Status (dropdown) | Delivery Date | Feature (checkbox) Client A | Rescheduled | 2/5/2020 | 0 Client B | Postponed | 2/12/2020 | 1 Client A | Confirmed | 3/17/2020 | 1 Client C | Requested | | 0 I have a sheet I'm using as a template to create…