-
Need Formula for Automating RYGG Balls
I need help writing a formula that will change the color of the health RYGG balls depending on how close to the end date we are. If end date is prior to TODAY, = Red If (Today-Start Date)/(End Date-Start Date) is greater than or equal to 50% = Yellow If (Today-Start Date)/(End Date-Start Date) is less than 50% = Green If…
-
Formula Syntax Help
Hello, I am creating a sheet to track calibrations for the equipment in our department. I saw the function to add months to a date from another cell https://community.smartsheet.com/discussion/smartsheet-formula-syntax-help =IF((MONTH([Purchase Date]1) + 9) > 12, DATE(YEAR([Purchase Date]1) + 1, MONTH([Purchase Date]1) +…
-
Use cell links in formulas
I'd like to suggest as a new feature request the ability to use cell links in formulas. There are many occasions when I would like to sum the values from multiple cells on various sheets into one cell on another sheet.
-
Time stamped entries
Hi All, Is there a way to create a column with time stamp entries like the comments section? I want to make a highly visible column of entries that show when the entries were made. Right now the comments column can not be renamed or even copied. Regards Tony
-
Sorting Capabilities Changed?
Since the newly updated sheet, I can not for the life of me sort a column. I know I have to remove all filters but the option to sort is still greyed out. Please advise....
-
Lead time Formula
Hello, I'm trying to figure out a formula or a way to make 2 cells work together and have the results in a third one. Here is the situation. this sheet is for procurement of items and their lead time to order. Example: in one cell we would put the date we would like the item to arrive onsite and in another cell we would…
-
If/OR formula
I can't see where I went wrong; I am trying to get two columns to calculate the number of days between two dates when one of the fields is "N/A". Here's what I have so far: =IF(OR([Initial Approval]1="",[Request for PR]1="",[Initial Approval]1="N/A",[Request for PR]1="N/A"),=(NA(),[Request for PR]1-[Initial Approval]1+1)…
-
saving docs in Workspaces
fellow SS users, My colleague, who has full admin rights, is not able to save anything into a workspace that i have created. I can't see any restirictions in any settings so I wonder how I allow him...and other license holders, to freely add to and use this space. Thanks, Si.
-
How can I count just Blank child cells?
I can make the formula work if the cell has a number in it but not if it is blank! I've nested IF statements until I'm blue!!!
-
Total count based on values from two columns
Hello, I'd like to check the text in one column and a check mark in the second column and then get a total count based on that. The first column is Scope which can be A or B. The second column is complete which is a checkbox that's either checked or unchecked. What I'd like the formula to do is check the Scope column. If…