-
Formula to return value based on multi options in another cell
Hey SS community, Hoping someone can support on this one. I've been searching and searching and not been able to find the answer as of yet! I'm working on a sheet that contains answers to an assessment. The answers are captured form an external form (ms forms) and added to Smartsheet via Powerautomate. One of the questions…
-
Automating Start Date
Hello, In my sheet I have a "Start Date" column that I would like to automate. In a separate status column I have a drop down option that includes, "Not-Started", "In Progress", "Completed". Once the status column is switched to "In Progress" I would like the Start Date column to automatically post the current date. Once…
-
when line data meets criteria, add some line data to new sheet
I have read a lot of the information, but unable to find the right formula for what I am trying to do. Hopefully someone can assist! I have an 'all stores details' sheet. When 'current store' is checked, I want row data to populate into a new sheet. EG: If 'current store' in 'All Store Details' is checked, return StoreID…
-
Uncheck box when the value in the dropdown changes
Hello community As the title states, I'm trying to have boxes uncheck when the value in the dropdown changes. I have attached an image. When "Stage" column changes clear "Fit Plan Attached", "Approval Sent", & "Approval" column check boxes.
-
IF, OR, AND, Color symbol
If next status is <> A or B and Status 2 <> not started or blank and today is 60 days from a date, Red If next Status is <> A or B and Status 2 <> not started or blank and today is 80 days from a date, Yellow Green
-
Trigger Checkbox check once week meets criteria
Hi Smarties, I have a Checkbox column that will be checked automatically when an End Date is met. This checkbox is then used in a report and published that particular row in a dashboard. =IFERROR(IF(WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()) - 1, 1), "") However, I totally overlooked that this will also trigger…
-
Formula Question
Hi Everyone! I am trying to create a formula for the following. I have been trying IF, IF/AND, and IF/OR, but I just can't seem to get it right. I have 5 approval columns in a spreadsheet. Each column has a drop down and the person approving will select approve or reject. I then have a 6th column that will be the final…
-
What is wrong with my Formula? I want to do a countifs to count by deal stage within a date range.
I am counting all of my deals in "Lease Negotiation" in the year 2023. =COUNTIFS({Master Pipeline Tracker Range 1, "Lease Negotiating", >=DATE(2023, 1, 1), {Master Pipeline Tracker Range 3}, <=DATE(2023, 12, 31)) Please let me know what I am missing here.
-
What is wrong with my formula? I want to do a countifs to count by deal stage in a date range.
I am trying to count all of my deals in "Lease Negotiating" that have 2023 open dates. =COUNTIFS({Master Pipeline Tracker Range 1}, "LEASE NEGOTIATING", >=DATE(2023, 1, 1) {Master Pipeline Tracker Range 3}, <=DATE(2023, 12, 31))
-
Formula to always Summarize all 5 cells to the right of a column, including new columns added.
Hi, Is there any formula that can return the summary of any of the 5 columns to the right of this column layout, no matter what columns are inserted from there on? I keep on adding columns, but I want it to always calculate the columns that are now (or in the future) within 5 columns to the right. Thank you,