-
Dividing a value under "1" i.e. 0.71 isn't working
OK, so I have a sheet that's giving me some details on contract spend. One column is telling me the remaining value in a contract, another column is telling me how may weeks are left until the contract expires - i then have a 3rd column that is calculating how much weekly spend is available before the contract expires.…
-
How can I add character count, like in the content calendar template?
I'm trying to add the function of character count in my template. It's the same feature that's used in the Content Calendar feature. What is the formula?
-
status averages
is there a way to get an average how long a cell is in a certain status? currently have status cells are in text. so i would assume i would have to assign a value to them but after that im not sure which formulas to use.
-
COUNTIF Function
Hello, I have a column (column 1) that is limited to a multi-select drop down menu with 5 options call them red, blue, green, yellow, and orange. Every row in column 1 has multiple color selections. How would I write a COUNTIF formula to count every instance of red? I have tried =COUNTIF(column 1, <"red") but do not know…
-
Trouble with Formula for RYG/Health/Status Columns
Hi There, I'm brand new to Smart Sheet and still learning the abundance of inner workings - hoping to find some help with what is probably an easy formula but I can't seem to get it right! I'm trying to change the color of the RYG ball under my 'Health' column based on the 'Status' column. For instance: Red = Canceled/Not…
-
Getting a base number out of a list
Hi I could use some help with this list of numbers. what i am looking to do is come up with a formula that will return 1234 no mater how it is entered. 1234 is just an example number but it could be 52368 or 65875 but it will always be a numeric value needs to be returned. it could have any number of letters or leading…
-
Calculate total of each entry from multiple drop down selections.
I have a database which is filled by clients through form. In Area column, the clients will update the area from their house where the issue is located. It is multiple selection. Screenshot attached. In my metrics sheet, I want to find out the total number for each entry. When I put 'countif' formula, it only considers…
-
Cross sheet reference
I have two sheets. In one, employees enter the time they spend on each task. This gets totaled to the column [Total Minutes]. On the second sheet I want to only show date and total minutes. I have no problem doing only one row but when I try to reference a complete column I get the error. This is my formula for one row…
-
Helper columns to allow parent row data to be included in automation
Hello! I am trying to work on refining our automation in a project management tracker we have. Our parent row has the start and end date for the entire project. I am trying to create a helper column that would automatically count days to end of project for each project and repeat that number for each line of a project to…
-
Is there a way to change info in a master sheet to be reflected in sub sheets?
Hi all! New to Smartsheet so please bear with me and my (maybe perhaps)silly question but one I haven't been able to find a solution to. I am using Smartsheet to compile online student registrations. My format: I have one "Master Sheet" where all of the registrations flow into. I have created "sub" sheets, and created work…