-
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…
-
Form Logic, Restrictions & Evaluating
I'm building a Form, and one of the criteria is Budget. I would like to evaluate the Budget field as they tab-off of it, before the form is submitted as I know there would be times people will enter an amount that won't be sufficient. The scenario would be - the Budget is $1,000, but based on the number of calendar days, I…
-
Vlookup on sheet using form submission
I am using a form to add a new row to a sheet with each submission. I have a field on the form that the user selects if this is a new contact or previous contact. If it is a previous contact, I want to pull information from another sheet for this contact. To do this I have a Vlookup formula that I was able to get working…
-
delete data from a cell without eliminating the formula
Is it possible to delete data from a cell without eliminating the formula?