-
Are there any known issues where the Smartsheet calc engine produces incorrect results?
I have encountered a scenario in a sheet where the calc engine is undoubtedly producing an incorrect result. I've opened a ticket with support but I have an impending demo so am hoping someone here might have some experience with this sort of thing, OR can provide some insight into how long one usually has to wait to get a…
-
AVG(COLLECT 0%
I have a sheet that I am using AVG(COLLECT on. I have it working base off my criterion_range. The issue that I am running into is that I have several days with 0% and then a few days with 50%. It looks like it is not taking the days with 0% into the average and I need it to. How can I fix this. Thanks
-
I am trying to calculate benefit eligibility dates.
I need to calculate the 1st of the month following 60 days of employment. Ex. If a hire date is 1/15/2024, then I would need the formula to return 4/1/2024 (60 days after 1/15/24 is 3/15/24, so April 1st would be the date they are eligible for benefits).
-
CountIF for Overdue Tasks that are not Complete
I'm trying to count overdue tasks in Sheet Summary, but only for Tasks that are not marked as Complete. (Marked In Progress or Not Started). =COUNTIF(Status:Status, OR(Status:Status = "In Progress", Status:Status = "Not Started"), [End Date]:[End Date], <TODAY()) It returns the #incorrect argument set error. Any thoughts…
-
IF Statement for multiple data points from a main sheet and reference sheet
Hello, I need help with a IF statement that I am trying to have work in a main sheet, that looks at other cells in the main sheet and reference sheets. The formula I have returns UNPARSEABLE, =IF({Eligibility Review Status}=”Ineligible”, “11. Ineligible”, (IF([Date of Withdrawal]@row >0, “12. Withdrawn”,(IF([Date Closeout…
-
Using CountIfs for months and year
Hi,. I am struggling with my formula to CountIfs. Currently, I just have a COUNTIF formula in there to count from a reference sheet, the number of requests that came in by month only. I need to update this to be COUNTIFS though so that I can add in the year, so that I can see totals for each month/year vs just all of…
-
Select Multiple Values using IF formula in Multiselect dropdown
Hello, I recently created a multiselect dropdown column to track required approvals based on roles (see below). What I want to do is automatically fill in values for that column based on if an associated contact column is filled in or not. So for the example shown below, I'd like to see "Project Owner" and "Man & Ops" be…
-
Pause Time Tracked
I have a request to create a way to track a certain record's time since it's been opened, but the user would like the tracked time to not include when it's in a certain status. For example, if the record is in "Open" status for 2 hours, have 2 hours tracked. If the same record is changed to "Waiting on feedback", however…
-
Generate Document Automations Errors with Modified Column
Hi all, I'm encountering some issues with my generate document automation - The overview is: I have a sheet with a form input (Sheet A) and a main log (Sheet B) - the intent is to have users fill out the Sheet A form with each inspection, and that info is index collected into Sheet B to keep it clean and not have all the…
-
View activity of a certain user for a time period?
Lets say user1@smartsheet.com is starting to slack off on their work duties (or really killing it,) and I want to be able to see what all columns/cells they have modified in a day, week, month. Is there a way to create a report for this?