-
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…
-
Multi-select string operation
Hi all, I have three columns which have the same drop down options: requested, received and pending. I would like the "pending" column to have all options from the "requested" column except for what's in the "received" column. For example: under "requested": option 1,2,3,4; under "received": option 1,2; under "pending"…
-
Trying to create a Projections sheet and need some suggestions please!
Hello everyone. I am hoping someone may be able to give me an idea on how to create a projections sheet for our engineering projects. I would like to build it out so I can spread the total hours per staff type over the duration of the project. I have tried a few different ways and cannot seem to figure out how to create it…
-
Lookup & Display First Non Empty Cell In A Range of cells within a column
I am attempting to write a formula in a header cell that returns the first Non-Blank row in a series within the related column. Excel permits this by using the Index and Match formulas but requires that "CONTROL, SHIFT & ENTER" be pressed for the formula to work. When attempting this in SmartSheet, I receive an "#INCORRECT…
-
IF/Match
Good afternoon, I'm having a problem with the below formula. I'm trying to do a formula that will check Invoice numbers on two sheets. If they match it will say yes, and if there is no match it will say no. However I'm getting Invalid Data type when there is a match, and No match if they don't match. =IF(MATCH(Invoice65,…