-
If & Workday Formula
What is wrong with my formula? I want to calculate 3 workdays from the survey request date but only if the site plan test fit is checked…
-
SUM Rows in Column A that meet multiple criteria including distinct values in Column B
I am trying to use a formula to: Referencing other sheet(s)… Sum story points by PE (Person) if: The Parent PCR (Identifier) is Unique The PCR Status is one of 5 options The PE assigned is an exact match (ie "Derrick Franklin") Here are a few that I feel are close, but not giving me the exact number's I'm looking for: This…
-
How can I get support after creating a case?
I opened a case and was given a resolution that did not help. How can I speak to someone to share screen and get the support I need?
-
How to index /match that has multiple dates- but I want the latest one
I have read so many index/match, max/collect, and index /collect questions, and all of them seem to be just a little different than what I need, and I can't figure this out. So I have two sheets, one data sheet that I am pulling from based on criteria from another sheet. Except the data sheet has multiple entries and I…
-
Cannot deselect "All Columns" in the Columns Included when creating a dashboard from a report
When I click on the x to remove All Columns to select which columns I want included in the chart it will not be removed. Also, when I try to add columns in addition to All COlumns being selected it provides an error- I am trying to build a chart widget that shows a "column" or bar chart breakdown of the count of items by…
-
Trigger using changes from?
Is there any way to create a trigger that uses "changes from" blank "to" any value? I am having an issue where when an employee manually changes the data in the sheet it is sending a notification because the way it is setup now it is when x changes to any value it sends the notification (this info is populated through a…
-
IF ERROR function - Help request.
Hi guys, I'm working with the following formula: =IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row) = 1, "January", IF(MONTH([Start Date]@row) = 3, "March", IF(MONTH([Start Date]@row) = 4, "April", IF(MONTH([Start Date]@row) = 5, "May", IF(MONTH([Start Date]@row) = 6, "June", IF(MONTH([Start Date]@row)…
-
Moving Rows between sheets
Hi! I have a Original sheet with data being inputted by different users and locations. I was trying to build out reporting so I moved one locations data to another sheet. Is there any way to move it back to the original so I can change it to copy rows to the secondary sheet instead? I don't want to risk losing all the…
-
Need help excluding weekends in estimated completion date formula
Hello! I am currently working on a Smartsheet that estimates how long a project should take depending on a multitude of variables. So far all my formulas are working great, but I am using the following formula to determine an estimated project completion date: This formula is unfortunately accounting for weekends as well,…
-
Formula to count multiple cell values and their dates
I am looking for assistance in creating a formula that will allow me to isolate values in the Provider/Resources cell, the Type cell and count based on Visit Date. Below is the a snapshot of the sheet. As you can see, there are multiple names in the Provider/Resources column, as well as the Dept column. The first name in…
