-
How to assign task to multiple contacts and track for each contacts completion
Hi, I'm building a sheet of tasks where some tasks will be assigned to multiple contacts and each assignee/contact will need to acknowledge that they've reviewed/completed the task. Multiple Contacts is enabled on the "assigned to" column and the preference is to have only one column to track assignees. Looking for help on…
-
Forumla help sought so cancelled tasks are not counted as at risk
This formula surfaces 'At risk tasks' to a project rollup dashboard report. It does so based on the criteria of due date in the past and status other than complete. =IF([End Date]@row <> "", IF(AND([End Date]@row < TODAY(), Status@row <> "Complete"), 1, 0)) Question - What needs to be changed so that it does not surface…
-
Metrics Widget - Summarize from Many Sheets in a Workspace
I want to add a Metric widget to a Dashboard that totals the number of projects that I have in another workspace. Each schedule (sheet) in that workspace has standard summary fields that I use in Reporting. When a new schedule is dropped into the workspace, it is automatically picked up by all the reports that look at that…
-
Users having issues with accessing published sheets
HI I have had several users reach out to me indicating they are no longer able to access a published sheet. They have been able to access in the past but now they are not. Nothing has changed with these published. Yesterday for one user, I deleted their account and re-added. Once he accepted the invitation, he was able to…
-
Remove Reply in Smartsheet Button from Comment Notification
Hello, I use the Comments of the Sheet to communicate with other people regarding the Requests we have in the Sheet. The comment notification that is sent automatically when a user has mentioned another user in a comment is very useful. However, I would like to remove the "Reply in Smartsheet" button that is shown at the…
-
Datamesh very slow to update
Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?
-
Concatenate Formula; IFERROR / ISBLANK = To pull all dates where the date columns are not blank
Hi All, I'm stuck on working on a concatenate formula that pulls out all filled in date columns only. Currently unsure how to integrate IFERROR and ISBLANK functions in this formula to pull out only the date columns that are not blank! Would like some assistance on this :) Thanks, Andrei
-
Formular: Only two requests each department per week
Hi Community, I have a sheet request form that capture transport requests from each department. Heres my scenerio: For my organsiation a request for transport is allowed only 2 request per week for each department. Requests more than two is automatically cancelled for the department. what formula can I use to a helper…
-
Two jobs in one spreadsheet?
Hi, Thanks in advance for your help. I have two sets of duties within my position: one set as Sustainability Engagement Coordinator, and one as Energy Coach. How can I use smartsheet to track the amount of time I spend each week on work for each set of duties, and track projects on each? Or do I need separate sheets for…
