-
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…
-
Inventory Formula Question
I am trying to keep track of items we have to give out to community members. Mostly I am just making sure I know when I'm getting low on a certain item. I made two sheets, one with the name of each unique item and one with more details that allows me to keep track of the person and date the item was given. Those details…
-
Logic not working properly.
I'm trying to add 5 different logics. If question number 2 "does not contain" 24, 23, 22, 21 or 20 I want the error box to come up. I enter in the first logic step and it works, once I start adding more it stops working properly. Now, when ANY number is entered for question 2 the error box appears. What am I doing wrong?…
