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 …
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 she…
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 Facilitato…
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 Met…
Hi everyone! I am using this formula in the Date column to pull a date if 2 criteria are met (name of the client and the specific module): =INDEX({Date}, MATCH([Column11]3, {Client}, 0), MATCH([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 sev…
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 "Nego…
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 wa…
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 returnin…
Hi, Is there anyway that we can copy parent row into the child row and apply to the whole same column without changing the parent row information? For example: =Parent({Test]@row) works if I put into …