-
IF and Date with N/A
Hello, I'm attempting to put to arguments together keep coming up with "Invalid argument". Each of these work individually: =IF((Date@row < TODAY(), 1, 0)) =IF(CONTAINS("NA", Date@row), 1, 0) My goal is to check the "date" cell. If it less than Today, check. Or if it contains "NA" then check. How do I put these together?…
-
Date formula that returns: Friday before the last Tuesday of the month
Hi everyone - I'd like to pick your brain: I've been asked to automate an update request to be sent on the Friday before the last Tuesday of the month. Is there a formula or a way to calculate this date? Thanks in advance for your help!
-
Use Max Collect to find most recent record with value in multiselect columns
I have a sheet with 2 multi-select columns. The value options for the 2 columns are the same, and are listed in a 2nd sheet. In the second sheet, I'd like to write a formula that finds the most recent date where the value is present in one of the two multiselect columns. Once I have that data, I'd like to know which column…
-
How do I create a formula for a Parent's "Assigned to" Inherit from Active Task
Hello! I am using an agile template to plan sprints for my team. I'd like the Parent to take on the ACTIVE subtask 'assigned to' contact. For example, the 'assigned to' column for the Parent would equal the sub-task's 'assigned to' column that is currently active (as indicated by 'stage'). Is this possible? something like…
-
Checked box applies formula to another row
Hi, Is there a way for when a box is checked to have the formula below automatically apply to the Health column? Basically, we only want Critical Path items that are checked for the below to apply to. =IF(Status@row = "Completed", "Blue", IF([Estimated Completion Date]@row >= TODAY(), "Green", IF([Estimated Completion…
-
Creating an At Risk Formula
Hello Community, I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the check box column and the Due Date is within the next 3 days. I've made several attempts at using an IF/AND formula, but can't seem to get it to work properly. Any assistance you can provide would be…
-
Automatically Check a Box upon entering a date and time
Hello, In my Smartsheet sheet, I'd like to set up a system to check off meetings automatically. I'd like to enter a date (ex: 04/15/23) in a column and the time span in another column (ex: 12:30 - 2:30 PM). It would then automatically check a box in next column if the start time have already passed. Any advice would be…
-
Reference column at level zero and ancestors to pull in data to new columns
I want to pull series and item from the series column into their own columns The series is part of the item number as well: B060 (series), item in series is B060-122 (item) In a new column titled Series ID I want the series number on every row level 0 and level 1 In a new column titled Item ID I only want the item # on the…
-
Form Options - Automation
Good morning, I'm trying to create a form in for entering and/or removing equipment from our site. There are times we have new equipment installed where equipment is not removed, and vice versa, but also times where both apply. Essentially, our wish is that the contractor would complete the form and if they check a box…
-
Cross referencing multiple forms using a formula?
Hello there, I have a destination sheet, where I need to reference 3 types of data from 2 other support sheets that I have made. Those are (cost of airfare, date travel was booked, and cost on non-airfare). One of the support sheets has a form that will record airfare cost, and travel date booked from recipients. The other…
