-
Help with a Formula
I have a Target % Complete column in a project plan template that essentially looks to see if you are tracking to the % complete you should be based on today's date and the start and end date of any task (or tells you that you are missing dates). I've included the formula below that returns the result of what your target %…
-
Permissions to edit cells
Hello all. I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status. The question is possible edit permissions on cells to avoid that any user could change it? Thanks
-
NEW ZEALAND TIME ZONE & TODAY() function mismatch
Hi Smartsheet Team , I have an issue with the Today() function not reading my date correctly . I contacted you and you provided me with a long formula to overcome this but it still didn't solve the issue for us . The formula i'm using now is : =IFERROR(IF(AND(ISBLANK([Resolved Date]@row), [Created Date]@row <= TODAY()),…
-
Approval Request after a modification
We are working with an approval workflow. In this approval flow the user has the possibility to change important things in the approval request. Problem: approval request is already sent We solved this by generating a new approval request when something in the request has changed. Problem: the persons who gets the approval…
-
#INVALID DATA TYPE when using COUNTIF Formula
Hey Community - I am having an issue trying to use the COUNTIF formula. In this use case, I basically have a formula in the first column to show if start and end dates match with other columns in the sheet. All I want to do is count the number of "Yes" cells, but when I try to use the COUNTIF formula, I get an #INVALID…
-
(2) Reports in a Dashboard Showing the same answer?
I have 2 reports sitting next to each other in a dashboard. One shows a summary of what was due yesterday. One shows a summary of what is due in the next 5 days. "Due Yesterday" report is set to show anything with an End Date in the last 1 day(s) "Due in the next 5 days" report is set to show anything with an End Date in…
-
Designating who gets a back up email
Is there a way to change who gets notified of a recurring back up? Right now it states the workspace owner will get notified. Is there a way to designate who gets the email other than the workspace owner? Thanks, Paul.
-
"Recently Opened" Navigation bar Question
Hello All, I have been a huge fan of the "recently opened" Navigation tab and have about 30 sheets pinned. I do use various sheets at various times, however, and would like to rearrange the order of these sheets as well as be able to bucket them. I understand that this wasn't quite the point and workspaces/sheets were made…
-
Sheet Summary Report - Want to edit fields within report
I created a Sheet Summary Report, and have found that the fields within the report are not editable, unlike a Row Report. In a Row Report, I can click into the cell directly within the report and update it. On my Sheet Summary Report, the cells in report are locked down and uneditable. Am I missing something in order to be…
-
Formula Help - Countif in Multi-select column
Hello - Two formula questions: 1. I am trying to input a countif formula into a Summary field that will count how many times the name of a specific team appears in a column that uses a multi-select dropdown. This column also has some fields that are blank. Below is what I have tried and am receiving an 'Unparseable' error.…