-
Auto-Revoke/Cancel Update Request
I have an [Assigned to] contacts column with multiple contacts per cell allowed. Based on certain criteria I have a workflow setup to send an "Update Request" to all of the contacts in [Assigned to]. However, I only require 1 (one) of the contacts to provide the requested update (as they chose based on their availability).…
-
Workflow to cancel an Update Request
Problem: I have a workflow that sends out an update request to the assigned individual for a task when that task moves into a "late" status. The goal is to get that person to go into the project plan and adjust the end date and or the status of the item. Many people make this change by editing the smartsheet directly…
-
Searching more than one worksheet to return value
I am utilizing multiple worksheets (one for each year) but have one sheet that has some consolidated information, and I would like for it to be able to pull from the appropriate year sheet. =IFERROR(INDEX(COLLECT({Quote Log 2024 Quote Status}, {Quote Log 2024 Quote #}, @cell = [Quote Number]@row), 1), "") I would like for…
-
Lock single cell
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea
-
Formula to bring back the 3rd Friday of next month
I need to calculate the 3rd Friday of each month consecutively on a sheet. I am looking for a formula that will take the date of the previous line and spit out the next month's 3rd Friday, in sequence. Any help would be very appreciated! Thank you.
-
Filling out a date on a past status
Is there a way to fill in the date for a status that changed in the past? I didn't have the automation before, now I need to update the date to the day that the "status closed" was changed. Is there a way to automatically do it or do I have to do it manually now? 😓
-
INDEX/MATCH I'm trying to match the Branches names
This discussion was created from comments split from: Index/Match vs. Index/Collect?.
-
% Complete column not displaying as a % or calculating parent lines
I have a % complete column, with dependencies enabled, however the information is displaying as 1 rather than 100% and is not calculating the parent percentages at all. Am I missing a formula?
-
View Collections from the Browse Screen
This enhancement request will allow the user to access and view Collections from the Browse menu. Currently you have to navigate into the workspace and click into an asset to view the "Workspace Panel" in order to access the Collections.
-
Workspace Query
I am setting up a Smartsheet workspace for Fire Call Point Checks that are to be carried out weekly and on a rotating basis. We have 4 different buildings, each with their own set of call points. So far I have a basic schedule set up for each building, with due dates. When the check becomes due, it will flag and the check…
