-
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?
-
Start auto-numbering from a chosen row
Good morning everybody ; As show in the picture below , I have a project schedule which starts from the row number 3 and I have a coulumn which contains auto-numbers ( Code livrable ) . But I want auto-numbering starting from the row number 3 whil row number 1 and number 2 remains empty . Is that possible ? Thanks in…
-
Adding formulas together / Invalid Data Type
While I can get the formulas to work on their own I can never figure out how to pull them together in one string. This time, I think it might be close but it's returning an Invalid Data Type which makes no sense as I know that the column that the formula is in is RYGG which is what I'm asking it to return. My use case is:…
-
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%…
-
Summary formula to count the number of rows in a sheet that have no children?!
Hi, I've been racking my brain trying to get this formula to work! I can create a helper column in the sheet and display the number of children each row has, then simply use a CountIf function - if Children=0, but, I thought i could use a COUNTIF with @cell to not require the helper column? I have tried the following…
-
Expected behavior for DATEONLY when embedded in other functions
I feel like the formula below should function to remove the timestamp off of the cell in created at the same row as the function, then count all cells in the created column in which the days are the same. =countifs(created:created,dateonly(created@row)) Currently this formula counts when the date AND time match. In fact,…
