-
IF statement to Output Column Contact List Name
Hello! I feel like this is a fairly easy formula, but having issues populating the ACTUAL contact name vs. the TEXT value using an IF statement. Goal: In this example, when I change the status to phase 1, I would like the Current Assignee cell to populate the contact name. However it is populating the value and not the…
-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
Pull reference data from another sheet while filtering out based on a multi-select dropdown
Hello, I'm new to Smartsheet and I'm having a bit of trouble with referencing data from one sheet to another. I think this question has been asked multiple times, but I'm confused on the format of the formula's as this is a complex problem. I want to have a master 'Parts List' which is a complete list of parts with some…
-
How to count checkboxes-checked, between Nov 1st, 2020 and December 1st, 2020
I am looking for help creating a formula that works with the above question. I will replicate it for each month through one fiscal year timeline. Currently I have this formula which results in UNPARSEABLE. =COUNTIF({Data Range 3X}, true), COUNTIFS({Tuning Release Date Range}, >= A11, {Tuning Release Date Range}, <= A12) I…
-
Another automate RYG balls for parent based on child
Hi, I have a project plan with multiple levels of children. Currently, the RYG automation is as follows: =IF(Status@row = "Done", "Gray", IF([Due Date]@row > TODAY(+7), "Green", IF(AND([Due Date]@row >= TODAY(+3), [Due Date]@row < TODAY(+7)), "Yellow", IF([Due Date]@row < TODAY(+3), "Red")))) What I want to do is create a…
-
Trying to Work with the VLOOKUP Function but hitting a wall
I'm attempting to access a separate sheet with some contact details for various clients. On my CLIENT SHEET I have 8 columns: Licensee, Billing Company, Contact, Contact Email, Street, City, State, Zip On my PROJECT SHEET I have various other project details, but one column is also named "licensee". In the Licensee column,…
-
Circular Reference Error Not Appearing Initially, then appears later
I've created a few summary sheets which use VLOOKUPs from my master data sheet, as well as other sheets. I've noticed that when I try to do a VLOOKUP, the formula will initially work, and pull the data as expected. However after some time, I'll re-open the same summary sheet, and see that the VLOOKUP Formula has an error…
-
RAG status formula using TODAY and end date
Hey smartsheet community, any help fixing this RAG status formula? I am trying to automatically show RYGG balls dependant on the end date and today's date. With the exception of cancelled and complete tasks; any task with the end date TODAY or in the future should be green any task up to 3 working days in the past should…
-
Column formula do not appear in form
Hello, Hope you all are good in this crazy time. I'm really new in smartsheet and maybe what I'm trying to do is not viable, so I'll try to explain myself as details as possible: I want to create a form with some fields "auto-fillable" based on a cross-reference VLOOKUP formula. I have a main sheet and there is a column…
-
Getting #UNPARSEABLE after using IFERROR
Hi all, I've got this awesome formula (Thanks, Paul Newcome!), which calculates the difference in months between two dates: =(12 - MONTH([Actual Study End Date]@row) + (((YEAR([Expected Expiration Date]@row) - YEAR([Actual Study End Date]@row)) * 12) - 12) + MONTH([Expected Expiration Date]@row)) +…