-
Average children with IF
hi, i have sheet with ~300 parent row and ~1200 children row. i try to sum the progress in parent row with IF on his children. for example : if one of the children row is "sent to fabrication" he get 100% and i have five children row i want to see in parent row the value 20% progress. (1+0+0+0+0)/5
-
Formula to show Status based on several fields that may or may not have a date entered.
Hi, first let me say that Smartsheet formula's are fairly new to me so if I'm approaching this all wrong please tell me and I'd appreciate any suggestions. I'm trying to establish a formula for a Text field that will automatically populate with the appropriate status based on whether several other fields have a date in…
-
Complicated Approval Workflow Question
I need some help with writing what I feel is a complicated approval workflow. Currently, we have a CapEx approval process that is done in Excel and requires approval from a Manager, Director, VP, and VP of Finance. If the CapEx is greater than $50K our President needs to sign off and then it needs to go back to the VP of…
-
Add a ticket number on the automatic response form
Hello, I would like to add the reference of the ticket number / or on the order number on the automatic response form. Example : When a Customer fill the form, he will receive as a response : "Hello, your order has been submitted, your order is the "XXXXXXX"(reference to a row on the smartsheet). Is it possible please ? MT.
-
Different View of Report, depending on the location, from where the report is accessed.
I have a report called "My Tasks" in my workspace, I also have a shortcut to this report in my Dashboard. When I click the report from the Dashboard shortcut, the view is different from when clicked through the workspace itself. Different columns are seen in the two views, although I have set it to show only one. It even…
-
What Formula Would Handle This?
I want the top row to calculate everything below it. I was using the Sum Children formula, but once I made the indent below with "Flavored Kre Pre-Launch", it won't calculate anything below it (just only if I put something in that same row). So, is there a way to write the formula in the top cell to read all of the ones…
-
SUMIF with CHILDREN
Working on a formula within a sheet where I am trying to sum estimate amounts based on their % closed. I have 2 categories we have created using children/parent (indenting) I want to only count the projects that are within 1 category. My formula is =SUMIF(CHILDREN({A LEADS}), ({% CLOSE}=25%), CHILDREN({Amount}) This keeps…
-
COUNTIFS FORMULA THAT REFERENCES A SEPARATE SHEET THAT ALSO HAS 2 SETS OF CRITERIA
Good morning, I promise I've looked high and low for this answer! LOL I have 2 sheets. We'll call them Central and Complete. They are identical. The 2 columns in particular that I'm working with are #1Signing Method (possible cell contents is either Paper/Esign) #2Month Opened (options are numbers 1 - 12). The goal is to…
-
Formula Help!
Hi there - I have 2 questions regarding formulas: I am trying to count all the cells in a column that are not the value "Professional" in FY19. I seem to be getting it to work by using the formula =COUNTIFS(FY:FY, "FY19", Source:Source, "<>Professional"). However, this is not counting cells that are blank in the Source…
-
IF AND formula with between dates
I'm trying to toggle and RYGG status field with a formula. The idea If the contract send day is more then 14 days ago and the contract hasn't been executed I want the status to be RED. If the contract day is more than 7 days, less than 13, and the contract hasn't been executed the status should be YELLOW. Otherwise it…
