-
IF OR/AND Nesting Part 2
Hi - I just asked a IF OR/AND nesting question recently and it was answered. Then I tried to modify it slightly and it is unparseable. Could you please look at this one below? =IF(OR(AND([Round #3 Price Sheet Status]@row = "Not Renewing"), AND([Account has Updated Renewal Added to TL]@row = 1,)), "Blue", IF([Price Sheet…
-
How to create a pie chart based on a subset of a larger file
Dear Smartsheet community members, I need some help in figuring out how to create a pie chart based on a subset of data, which will keep being updated over time. The source document has about 200 lines overall (as an example), and from these 200 lines, I want to be able to capture how many are "aligned" with our processes.…
-
I need to formula to show if my application is more than 90 days old
Example - I have a Today column, but need to know if Application fee invoice received date is more than 90 days from the Application start date , even if there is no application fee invoice received date. How do I show that in a formula?
-
IF Statement Confusion
I am perplexed by an uber simple IF statement that is giving the wrong results for only a few rows. I am using the following formula: =IF(Amount@row < "5000.00", 1, 2) where the amount column is in $. For all but 3 rows, the correct value is displayed. I have tried with $ operator and without cents but nothing works. I…
-
Is there a simple, elegant way to copy rows with linked cells to another sheet?
In my specific case, I have a summary sheet where each project has one row with data linking from a detailed project plan sheet (e.g. - Dates, Budget Hours, % Complete, etc...). I want to copy rows to another sheet where I will be creating Card views for specific sub teams. I want the data to be dynamic as changed only in…
-
Status Update Requests - When predecessor tasks have not yet been completed
We have set up daily status update requests for our projects for task owners 1 day before "Planned Finish" date. We run into an issue when one or more "Predecessors" have not yet been completed. The automation pings users for successor tasks, that they can not start/finish, as they are waiting for the predecessor task to…
-
Adding Case IDs to Smartsheet
Hello, I am trying to add a case ID for new rows that are being added to my sheet. I want the new row to be one number higher than the previous row (the smartsheet is set in reverse order, which is why auto-number is not working). I know I need to use IFBLANK and then add 1 to the row before, but I am not sure what the…
-
Update the cell value by 1 on the 1st of every month
Hi, I want to update the cell value by 1 on the 1st of every month. Suppose the current value of my Earned Leave Column is 10, on the 1st of every month I want to increment it by 1.
-
If response appears, total amount in another column
Is it possible to sum a set of responses if a condition is met in another column? For example: I have a column that indicates application approval status. I have another column that indicates the total award amount. This award amount column contains amounts whether the application status has been approved or not…
-
Using contact on a multi-contact column as condition for countifs.
I have the following formula. The range is a multi-contact column. There may be a single contact or several. The Contact8 references another cell with a single contact. I want to count any of the cells in the range that contain the contact. It may be mixed in with several others. I was trying to use the HAS or CONTAINS…
