-
Actual % Complete vs. On Schedule % Complete
Hope everyone is doing well? I'm looking for a formula or suggestions to accomplish the following: IF “On schedule % Complete is > Actual % Complete then the task is “Late”, “Red Ball”. IF “On schedule % Complete is < Actual % Complete then the task is “On track”, “Green Ball”. IF “On schedule % Complete is = 0% (Actual %…
-
Formula on Smartsheets not autopopulating
I have a Smartsheet that has formulas setup in the first two rows of the sheet. I have data on an Excel that needs to be copied and pasted onto this sheet. On copying and pasting upto 20 rows, Smartsheet has continued to maintain the formulas without any issue. However if I copied more than 20 rows, the formulas dont seem…
-
Keeping formulas when pasting rows of data
I',m in a bit of a pickle with one of our sheets. So right now I've got a sheet that is being filled in automatically with a script that I made. It is taking a CSV that is constantly growing, converting it into an excel doc, and then copying & pasting the entire thing into a smartsheet. This works great for the most part,…
-
Issue with Formula Autofill
Hello, I am currently trying to make an equation driven total column. Currently I am experiencing issues with the formula not autofilling to the next row. I have looked at the help page that describes the necessary criteria for autofill to take place. I plan on filling this sheet via a form and so far have been testing…
-
How to register a cell in a Text/Number column as a date in a formula?
I have a formula from Excel that I'm trying to duplicate in SmartSheet. The formula references row1 which is a month-year (eg JAN-20). This is a duplicate for the column name so it can be interacted with in a formula. So there are 2 elements here that I need help with. Can treat a cell from a text/number column as a Date?…
-
Countifs
Hi, I am trying to count the number of entries in multiple columns between dates in another column in a metrics sheet. Here is what i am trying however i am getting a error. =COUNTIFS(Design Services Projec Range 12}, {Design Services Project Range 4}, >=DATE(2020, 1, 1), {Design Services Project Range 4}, <=DATE(2020, 1,…
-
Automate RYG For Project Tasks
Hi All i am very new to SmartSheet. I am working on the project template which can help to highlight some tasks that have been overdue with RYG. Need your kindly help on the formula... 1. If task status is complete: Green 2. If the task status is Not Started: 1. Scheduled End Date is behind today: Grey. 2. Scheduled End…
-
Use a multi select drop down option to check a box
I have a drop down where you can select more than one option from the list as a status. I would like if Option "Canceled" is selected for a check box to be checked in column Canceled. Here is my if statement =IF([Info Center]1, "Canceled", 1) If Info Center shows Cancelled the check box says #Invalid if Info Center is…
-
Sum total minutes at a particular data center over the last twelve full months
Hi, Been trying to figure this out for awhile. Here's my issue: I am trying to create a rolling sum of the minutes that there is an outage at a particular data center over the last 12 complete months (not including the current month) by referencing another sheet in Smartsheet. We eventually want this number to update…
-
I'm stuck trying to do some basic arithmetic using the YEAR function
I'm trying to derive the number of years that have passed since a boat was either built or underwent a major refit. I have one column for date built and another for date of last refit. First, I wanted to return a blank if there is no last refit date, and then to calculate the number of years since the last refit if there…