-
IF Statement with Symbols in Sheet Summary
I continue to receive the "UNPARSABLE" error message for the following formula: =IF([Project % Complete L&P]# = 0, "Extreme", IF([Project % Complete L&P]# < 0.25, "Severe", IF([Project % Complete L&P]# < 0.5, "Moderate", IF([Project % Complete L&P]# < 0.75, "Mild", ([Project % Complete L&P]# = 1, "No Pain" "Very…
-
Date and Conditional Symbol - IF Then Statements
Hello, I have two columns: 1) Project Timing - A column with symbols. I only want to use the single and double diamond (ignoring the other symbols). 2) Target Start Date - A date when the project will start (can be in the future or the date may have passed already). How do I create a conditional statement that shows a…
-
Automatic Date when cell is changed/updated
Hi Smartsheet team, I looked through some previous questions regarding how to have a date show automatically when a specific column changes. But the only answers given was to edit a columns properties - auto number - Modified (date) to show when that row was modified, not necessarily a specific cell. I would just like to…
-
Simplify this formula to enter quarters based on date range.
Hello, I need help simplifying this formula. I need to enter a Quarter based on a date, For example, if the date is Jan 1 2020, enter Q120 in the cell. If April 1 2020 than enter Q220, and so on. I am using this formula, which is making the sheet to complicated and possibly impacting the performance. The crazy formula is:…
-
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.…
-
Countifs with Multiple Criteria and Referencing Another Sheet
Hi! I am trying to create a formula that will count the cell if column X (checkbox type) is checked and comlumn Y has "N "or is blank. I would like it to total on my metric sheet so I can generate a graph off of the data, therefore, the formula will be referencing this information from another sheet. Hope makes sense!…
-
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?
-
Automatic breakdown of hours into columns
Hi All, I tried re-importing the file from excel with formulas and this is what I'm getting (see pic). The idea is that I will apply the formula to all the columns and when I enter the start date and duration (which calculates end date), it will automatically auto-populate all applicable columns without me having to do it…
-
Overdue / Due <10 days
We are flagging items overdue as well as less than 10 days. The issue is when an item is past due we only want the flag on for Overdue not Due < 10 days so that reporting is appropriate. What I would like to do is check to see if overdue flag is set and not set the Due < 10 days. =IF(AND([Over Due]@row = "FALSE") =…
-
SUMIF formula based on a date range from anther sheet
Hi, I'm trying to create a summary sheet that gives me a summary of data from a master sheet. In the summary sheet I'm trying to first do a lookup on the master sheet for a date range of rows based on invoice date column. If the Invoice date is for the given week, then I would like to add the Amount column values for all…
