-
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?
-
Health Ball Color Base on Start Date, End Date, and % Complete
Hello, I am relatively new to Smartsheets. I am trying to write the following formula but continue to hit an "UNPARSEABLE" Error. I am sure I am missing something but cannot find the issue. I would appreciate assistance. This is the core rule I am trying to draft. Here is my formula attempt: IF([% Complete]@row = 1,…
-
Parent/Child Status
Hello, I'm trying to get a setup going in my project templates where the parent cell will update based off the input of of the children cells. For example, the main parent is "Onboarding", with children "Licensing", "Credentialing", "DEA". Then, each of those children has their own children to track individual providers.…
-
Sumifs - Cross Sheet Reference Range Movement
I am working on a calculation where one sheet has month on month cost for a year in columns. i.e. Jan Cost, Feb Cost, Mar Cost etc. in sequential order. In another sheet, I am doing some calculations to prepare the category wise costs based on the first sheet. For each month, all the conditions are same except for the sum…
-
Combining If/then with date population
I am trying to figure out a way to auto-populate a date, but only IF a specific condition is met. (Screenshot below) I used the formula =WORKDAY([1st Test Date] 1,6) to auto-populate the "Second Test Scheduling Date", but I would like this to only auto-populate if the column "1st Test Results" is "Positive". Any tips? I'm…
-
Date Calculation Formula to Return Friday of Week Calculated
I'm looking to return the Friday of the week that my date calculation result falls. For instance, I have a formula that calculates a Start Date by using "Due Date" - 40 WORKDAYS. I need to then have the result show the Friday of that week. My first WORKDAY formula works fine on its own, but not with IF(WEEKDAY...... added.…
-
Using custom value for auto-number in primary field.
I read an old post that said use =[Row ID]1 to copy an automated sequence number in to the field specified. I want more that than just 1,2,3. I would prefer V00001, V00002 etc.. to increment for each new row. Is that possible?