-
workflows
can a workflow be set to work like this somehow if area of business = Whittlesey and proforma raised by is any value the email email 1 if area of business = Hoveringham and proforma raised by is any value the email email 2 if area of business = London and proforma raised by is any value the email email 3 and so on as the…
-
How to Sum rows in a column based on date
I have a sheet set-up with distinct numbers project numbers in the rows with columns containing the months of the year. Each month I drop in actual activity for the current month and someone will forecast their spend for the remaining months of the year. Is there a way to have a formula that adds up the columns with actual…
-
Round date down to the nearest Monday
I have a column of dates and I need to create a column that would use that date to round down to the nearest Monday so i can count how many lines of data for a specific week with a date. I was able to get the week number but really need the date.
-
Combining If Error formula with my existing formula.
I currently have a margin formula calculating my profit margin. This formula looks like this =(Description5 - Description7) / Description5 When the sale price and landed cost are zero. I want my margin calculation to show 0% instead of #Divide By Zero. I know I need to use If Error formula but I ma not sure how this needs…
-
Calculating a date using a 'date' column and a 'number of days' column
I need a formula that takes a 'date' column and minus' the number in a 'number of days' column to show that calculated date in another date column.
-
Help with a formula based on conditions
Hello, I need assistance with creating a formula for the following: In the Annual $ cell, I would like the salary to automatically appear when two conditions have been met: the user provided the region (either US, CEMEA, LATAM, ASIA) AND the user has provided the Job Level. The salary should come from a different sheet (I…
-
How to use COUNTIFS by Week?
Hi- I am trying to write a formula for how many locations have officially opened per week of this year. This is what I currently have and all it gives me is 0. =COUNTIFS({Official Opening Actual}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY())) For the Official Opening Actual, I am referencing another sheet. I am not…
-
Formula's Broken
Team, Am new to Smartsheets and am trying to create metrics sheets that I can then create reports and dashboards from. The formula I am using, for example is: =COUNTIFS(Renewal Victories V2!Agent, "Name 1", Renewal Victories V2![Platform - BSG], "<>") I can't figure out why none of my formulas will work. I am trying to…
-
#Invalid Data Type Formula Issue - Formulating % to plan
Hello, I am trying to count performance to plan. I need to know if the required for ER is checked and the estimated complete date is DDMMYYY or earlier what the % should be. =COUNTIFS([Required for ER Start]3:[Required for ER Start]929, 1, AND([Baseline Estimated End]3:[Baseline Estimated End]929, AND(ISDATE(@cell), @cell…
-
Converting Excel Formula to Smartsheet
Hi, I'm struggling to convert a formula that I have been able to use in Excel to my Smartsheet. I want to use the formula to change the status column based on an End Date. The Excel formula is: IF($F2="p","No Date",IF($G2<$C$1,"archive",IF($G2<$C$3,"expired",IF($G2-$C$3<=$C$2,"Notifying","Current")))) F2 = a cell in the…