-
Formula to workflow a form submit that duplicates another entry
I would like some help please on a formula that would verify the submitted information from the FORM against all existing rows and inform the submitter/owner that a duplicate entry has been submitted. I want to workflow this so the row gets highlighted against the existing configuration of another row and informs the…
-
Using COUNTIF only if it qualifies...
I am trying to create a status report for items started. I think I have the formula for how many assigned, but now I need to identify of those assigned to 1 person, how many are started by that person. I tried =COUNTIF({Course Started}, {Team Movement Range 1"Donald Duck"}1). In the pic below Donald has 2 courses assigned…
-
Auto delete data from a cell once triggered?
Hi does anyone know if there is a way to delete data in a cell once that cell is triggered using a Zap? I was directed to Zapier, but man...I'm a newbie there. Has anyone done something similar? Basically -- am using a ranking system to prioritize projects. Once projects are prioritized, I would like to pull them out of…
-
Workflow not Triggering
I have a move workflow that should trigger when a checkbox is checked. The checkbox (picture below) has the column formula: =IF([Row#]@row > 50000, IF(IFERROR(MATCH([Row#]@row, {QC_Results_DB Row#}, 0), 0) > 0, 1, 0)) This formula triggers correctly, and checks the box when it should. The issue is that the workflow isn't…
-
CountIF with wild card
I'm trying to count the number of items in a column where part of the text shows. Is there a way to do this? For e.g., I'd like it to count up the number of rows from a column in which the words "ids" show up. Keeping in mind this only part of the text (e.g. some rows say "ids?", "ids due", "IDS? Client refs" etc." I've…
-
SUMIFS & FIND functionality with Summary Sheets
Hi All, I checked the archives and couldn't find a solution to my problem so I apologize if this has already been asked. I am trying to create a formula for my Summary Sheet that will provide the sum of dollar amounts but only if they are "Cost Savings" or "Risk Management". I am also trying to create a formula for just…
-
Countifs - 2 field ranges plus a date
Hi, I am trying to create a formula to count companies (1st column) that we won a project(2nd shows win/lose) in certain date ranges (example Q1 - January to April of 2020) I can get the count formula right that counts companies that we won the project with, can't figure out how to narrow it down with the date added into…
-
If function for children rows
Hi all, I don't know how to build a formula for the following: I want the parent row to show ''Pass'' when ''Pass'' is filled in for ALL children rows. If one or more of the children rows has ''Fail'' or ''Suspend'', I want the parent row to show ''Fail''. The children rows refer to the children rows of the parent cell.…
-
how to get sum of a column to include only certain date range
Please could someone help me with this? We have recently upgraded to be able to use the summary sheet as well as automated workflows, but neither of these have helped, and I think it maybe a simple formula issue? Basically, we use smartsheet for customers to place preorders of different products (approx 50 different…
-
Remove space and the letter after
Hi - I have a column with a list of names. Some name has first name, a space then middle initial and some has only the first name. See below example. I'm trying to work a formula that take only the first name without the middle initial. I tried this =LEFT([First Name]@row, FIND(" ", [First Name]@row) - 1), but it show…