-
Formula to calculate the amount of "done" rows for different years.
We do a lot of service jobs that we use smartsheet for. When its done they mark status as "Done". I know I can find the total amount of done rows by: =COUNTIF(Status:Status; "Done"). But how do I make the formula filter for jobs done in 2018 or 2019 etc? Kind Regards, Hugo Martinwall
-
Sum of a Cell Range, Dependent on a Dropdown Value
Is there a way to add up the total of a cell, dependent on the drop down value of the row? For instance... I would like to total the sum of the revnue (shown in the "Live Revenue Log") by the day (shown in the "Daily Revenue Overview")
-
Show dates beyond 90 days
We need to report on Jobs that has not been touched in the last 90 days. When we start a new Job we copy 4 "template" rows which include dates in the future. When I run my current report, it looks for dates on the parent row, but this row is showing the oldest date for the children. If a job has not been touched for over…
-
Function/Formula help to input Yes/No values as well as days outstanding based on two different scen
Hello, Can you please help me figure out formula's for the follow scenarios? I have attached a copy of my smart sheet that i'm needing to apply the formulas to. #1) PC Action w/in 5 days (Column F): If the date in column D (Date 1st update provided by PC) is less than or equal to the date in column C(Due Date) then YES…
-
Formula with OR Statement
Good evening: I am trying to add an OR to the formula below: =COUNTIFS(Priority:Priority, ="P1", Status:Status, ="Potential") Potential or Active Thanks for your help in advance!
-
Nested IF Statement Formula
Hello Team, This would be a great formula to incorporate into my daily SmartSheets process within my organization. I would like to know how to create a nested IF statement if this is the correct formula to use, that uses an RYG (red, yellow, green) light flag formula to set the status of a task based on its…
-
How do I populate a Contact List column using VLOOKUP or INDEX/MATCH
Is there a way to populate a Contacts column on a sheet using VLOOKUP or INDEX/MATCH and have the actual contacts from the original sheet populate into the new sheet as opposed to just the names? A bit more detail: The original contact column and the contact column on the new sheet are both Contact List type. Using either…
-
Resource allocation with multiple assigned to
Good day all, I'm working with resource allocation across multiple projects. Resource allocation is turned on for the account and then turn on and off for each sheet I want in the overall program. My understanding is that %allocation is assumed to be at 100% when there's no %allocation column specifying otherwise. In our…
-
Combining 2 Formulas
Hi, I am having trouble combining these 2 formulas: =NETDAYS([Date Sent To Rep]@row, TODAY() - 1) =IFERROR([Over Calc]@row, "") Right now I have 2 separate columns calculating, but would like to have just 1. Is it possible to combine these 2 formulas? I want it to calculate the net days, but if there is not a date inputted…
-
Health Ball Color Based on Dates and % Complete
We are utilizing the RYGB properties for our Health column and trying to improve the tracking of each task using this criteria: * If a task has NOT started and no progress has been made, no color indicator * If a task has started and is not late, but progress has been made, green color indicator * If a task is 100%…