-
Extracting text from a string and adding it to a date to get a date in the future
Apologies if the title wasn't helpful - wasn't sure how to better summarize the problem. I have two columns - Payment Terms (Dropdown) and Invoice Date (Date). The Payment Terms column is either numbers like 30, 45, or 60 OR a string that describes the discount if paid in a certain timeframe: "1%20 / NET 60". I have been…
-
Calculate days between two dates if the date is greater than 01/01/2024
Hello, I am trying to grab the number of dates between two dates if the manufacture date is greater than 01/01/24. This is the formula I am using and it is not working. =IF([Manufacture Date]@row, >DATE(2024, 1, 1), [Paperwork/HPLC]@row - [Manufacture Date]@row, 0)
-
trying to use countifs with multiple criteria's and a multiple selection drop down list
i've tried countif, countifs, count/collect. has, contains, i either don't get the correct value, or different errors such as incorrect argument, unparsable, ect. The formula that is shown comes back with a value of 0, when on the reference sheet it should be 1 for this column, during this month, for this employee. The…
-
Auto populate an email address from a Drop down list choice
I have a drop down list of Doctors names that staff pick from on a form (over 90 doctors). It will just be 1 name that is chosen from the list. I need the doctor's email address to populate in the sheet (not on the form) in the cell next to the name. I have a separate sheet with the doctor's names and email addresses. I…
-
Formula Help to bring data from two cells into one
I am trying to pull data from two cells into one. I think I almost have it but I keep getting an unparseable error. =IF([Person Responsible]@row <>, ""[Person Responsible]@row"", IF([Course Facilitator]@row <> "", [Course Facilitator]@row, "")) Thanks for the help!
-
NETWORKDAY error using cross-sheet reference
I would appreciate help figuring out this error please. I'm trying to determine the number of working days from the start of the project to when it went live (Hypercare). The calculation is in the Metadata and references the Enable Service date field in the project plan. It returns #UNPARSABLE error. # days to Hypercare is…
-
Merging several form questions into one column
Hi! I have created a form but am having some issues with how fields from the form are collected and reported to employees. The form is a sign-in for sessions. Attendees select their presenter from several lists (e.g. A - C, D - F). These presenter fields are set up as Contact Lists and linked to our users, and each form…
-
COUNTIFS function with multiple criteria
Hello! I've been having trouble with getting this formula correct. Here are the details. I want to count row A when "service expansion" is present only if row B has "qualifying" or "proposal" or "Negotiation" listed. I've tried several variations but can't seem to get this one!
-
Formula to list all projects that asked for additional funding and count number of times
All, I want to do the following, if it is possible, for metrics that I need to include on my Smartsheet dashboard. I have tried variations of =COUNT(DISTINCT(COLLECT without success. Here is what I want to do: In a metrics sheet, I want to go to my "2023 IAP Tracker ELT Approvals" sheet, then automatically list all of the…
-
Index/Match
Hi all, I have a form that collects data to a sheet. I am setting up a metric sheet to map out dashboard for control center. Here is the data collection sheet: Here is the metric sheet: it is returning no match in demo when there is 2%. the other formulas are pulling in data on the left with no error. I have checked if the…