-
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…
-
Columns populated by formulat not showing up in report
Hi, I have replica sheets in different workspaces and I am trying to build a roll-up sheet. Cell linking requires too much manual intervention, so at present I am creating a report. In the report I need an additional column for 'Client' as the source sheets are client specific and do not have this column. I know that I can…
-
Copy Row to overwrite formatting/Formula
I am trying to create a new sheet from a template in Zapier, (which is working fine). But I am next trying to copy a row from a "Master" sheet to that newly created sheet. It does create the new row, however it is always one row beyond my pre-filled formulas. In the template I have a formula to read information in [Column…
-
SUMIF, NOT Function, excluding specific text in return
Hi All, Hoping someone may be able to help with the final section of the below formula. it works as it should up unit the last bit. Aim of the formula: Sum of "ScheduleValue" if: ScheduleWCDeliveryDate is more than 01/12/2020 (Works) ScheduleWCDeliveryDate is less than 30/12/2020 (Works) ScheduledDespatchDate is Blank…
-
Using Smartsheet Forms
I have this schedule above (took out the names/privacy) for weekly schedules with my team. Normally there is a time frame in each cell for thee week like 9:00-5:00. Each week pulls down, I just have week 3 as an example. And this form: Is there a way that I can have someone enter in their information, for example if…