-
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,…
-
RYG Formula for Parent and Children Rows
Hello, I am trying to create a formula where the parent health turns Red if there is more than 3 red children health's, Yellow if there are more than 3 yellows, Blue if everything below it is Blue and the rest of the time green. Is this possible? I was using this formula for a while, but realized major gaps and it wasn't…
-
COUNTIF Question
Is there a formula that allows me to count the number of cells within a range that contain a certain string of text, where the cells in the range also contain other text?