-
Need empty column blank
I want to use a formula like this below but if there is no date in the other column to add +14 to, then leave row blank. =([CONFIRM OW PHOTO DUE]@row + 14) Need the "14" left blank
-
Tracking the overall RYG trend
We would like to track the # of weeks a project has been in its current status (e.g., # of weeks in Red). For example, has a project just turned red or has it been red for 6 weeks in a row? So far, I've figured we could keep a separate sheet whether the week's status is recorded (RYG), but how can I count the # of weeks it…
-
Countif date is in the next 30 days
Can a COUNTIF (or other formula) count if a date is in the next 30 days or is in the past compared to the inspection date? I have conditional formatting flagging this, but would also like to count how many date violations there are as I will eventually add more expiration date columns. I have only been able to figure out…
-
Help with COUNTIFS function
I am trying to create a countifs statement that would count the number of intakes where SP ID # are not blank and also where Stage <> Done or Cancelled. I have tried all of the following and it continues to give me #UNPARSEABLE =COUNTIFS(NOT(ISBLANK(SP Issue ID)))AND(Stage:Stage, <> "Done", Stage:Stage, <> "Cancelled")…
-
Restrict Cell Edit
Hi, The sheet is shared with multiple individuals with editor access which they need such access to provide responses. However, there is a cell that I want to be only edited by certain allowed individuals. Is it possible? Or will there be any sort of data validation/alert that I can utilize? Thanks!
-
How do I calculate the yearly revenue?
I have my sales pipeline in a sheet. It includes the first billing date in format "MM/DD/YY", total billable months and monthly billable amount. How do I calculate the revenue for each year? Most of our contracts are 36 months long. I can't seem to figure out how to pull the revenue for each year. Thank you in advance for…
-
Formula
Im using this formula to count the total # of quotes by month but wanted to add an another formula based off of my check box being checked. This is the current formula that I'm using =COUNTIF({Archived Installation Quote's Range 2}, IFERROR(MONTH(@cell), 0) = 1)
-
Changing a cell value based on multiple criteria
Hi everyone. I have been attempting this formula all day with no luck. Hopefully someone here can help out. I have a sheet with the following columns: Approved, Approval Need, Sr. Dir Comm Sol Sales Ops Approval, MA Dir. Comm Sol Sales Ops Approval, Reg Sr. Dir Comm Sol Sales Ops Approval, VP Approval The Approved Column…
-
Reference Sheet with Parent/Child Rows and Multi-Select
Hello, Sheet 1 - A sheet that contains parent and children rows with columns containing multi-selects. Sheet 2- A summary sheet that references Sheet 1. I want to count the children rows of the conditions: a) Team Red b) Area only has "West" included. I think I use COUNTIFS, but not sure how to reference another sheet and…
-
Task Completion Percentages
So I have a pretty basic Smartsheet tracker with set of Goals (parent) and group of initiatives(children) taken to fulfill the required goal. I am looking for ways on how to calculate the Completion percentages of goals... I was looking for something in combination of Time bound, No of child initiatives completed.. Is it…