-
AND / OR / IF : Nested
Hi As the Card View does not give you the option of using dates to view Boards, I wanted to find a way of doing this. I wanted the following to show in the "Due" Column Complete Late Next 7 Days Future Tasks What I didn't want to do, was to have to change the words myself each time as I am running a project with a lot of…
-
Display date fields from two different sheets
Hi, I'm tracking an estimated Start and End date (in a Project Sheet) and an Actual Start and End date (in a tracking sheet). In both sheets the rows where the dates are entered are CHILDREN and they both have an Asset # that I'm can match them to each other with. I'm looking for a way to display both the Project Sheets…
-
If & Date Calculations
Morning, I am new to smartsheets & having some trouble merging formulas together. I can get them all to work on their own but when I try to add them together they fail. I am obviously missing something. I have 3 fields; Expected Completion Date - dd/mm/yyy Status - Single Selection (Closed, Archived, Open, Overdue) Due /…
-
Create a table referencing another sheet
Hello Smartsheet experts I am looking for some guidance. I have one sheet "H&S Inspections" and now I'm trying to create an "H&S - Inspection Matrix" sheet. My monthly inspections log is set up: "H&S - Inspections with Form" What I want to do is create a table which shows that each location has completed a monthly…
-
Parent function to auto-populate cells
Hi everyone, Wondering if someone could help me with a formula to auto-label cells. I'm creating a project tracker for my team on Smartsheet and have automation set up for approval process, and also so completed tasks are moved to a new sheet. The problem is, on both instances, the row itself might not contain all…
-
IF(OR Statement giving #unparseable, using ; or , ?
Please help. I keep getting #unparseable error for the following formula: =IF(OR([DLExpiration Date]1 > TODAY(); [MECExpiration Date]1 > TODAY()); "NON COMPLIANT"; "COMPLIANT") I want the cell in my Status column to display as NON COMPLIANT or COMPLIANT if today's date is greater than the dates in columns DLExpiration Date…
-
Formula Help: Cross-Sheet lookup to validate & input information
HI, trying to have a cell in one sheet look at another sheet for its information. I need to check the value in a cell and if it equals 1 then copy the information from a different cell in the same row (in this instance column 1 in the range 'Design Phase Data Range 3'. However I keep getting the 'unparseable' error and…
-
What am I missing? Return a specific name based on a code.
Trying to return a specific name based on a code. So simple - I think my brain must have fried: =IF(Region@row)= EB, "Darren Kirby", IF(Region@row) = NB, "Doug Holmes")) Time to stop for today! Thank you!!
-
Approvals - how to require login?
My university has a Smartsheet site license. I can clearly see everyone in the contact list. I am creating a very sensitive workflow that requires department head approvals and have setup a smooth automated workflow to accomplish this. However, I just learned that ANYONE with the link can make an approval and the…
-
Formula to paste values generated by function
I'm trying to figure out an automatic way to run a function in a cell, and have that function paste the value, and only the value, to that cell. I don't want the formula to continue to exist within the cell. Similar to if I copied the cells post calculation, and did a paste-special of only the values. For example, =5+3…