-
Is there a way to restrict access in Dynamic View after a user have submitted info through it?
I'm creating a Dynamic View that a user will have the opportunity to view and check mark a box on a quarterly basis, this is to perform a QA check on whether other users should have access to certain files. The idea is that once the user (owner of said files) completes the check marks (if the users displayed should have…
-
Unable to Import a Google Sheet
I receive a 403 Error and message that states, "We're sorry, but you do not have access to this page. That's all we know" This happens to other users as well, is there a general setting that allows for this?
-
2 of 2: How to send Outlook emails using a template populated with Smartsheet data and triggering from Smartsheet
Continuation of 1 of 2 : How to send Outlook emails using a template populated with Smartsheet data and triggering from Smartsheet Details of how to send Outlook emails using a template that is populated with Smartsheet data and triggered in Smartsheet. This solution is complex. Some details have been blocked out for…
-
Help! Need to match a cell between two dates with complex conditions
Hi, I have a complex formula that i cant seem to figure out. I'll do my best to describe this below In Sheet 1 i have a unique identifier whose condition changes from blue to green after a certain date Unique identifier Condition StartDate EndDate 123456 Blue 1/5/2025 31/10/2025 123456 Green 1/11/2025 I want to ensure that…
-
What is the best way to setup cross-collaboration across departments in a workspace
How should I set up user access and the workspace for managing updates for division leaders? Essentially, it's a sheet that each division manager is to update on the current status of ongoing initiatives for the organization. Some initiatives can have multiple leads attached. Typically, the Division leader has a proxy that…
-
Need Gov‑Safe Method for Detecting Resource Conflicts (Date Overlap + Name Match Failing)
I'm working in Smartsheet Gov, which has several limitations that don’t apply in commercial Smartsheet (ex: no Manage References, no HAS(), no FIND() in COLLECT, and very strict parser rules). I’m trying to build a “Calendar Conflict” flag in my Project Plan sheet that detects when: A task’s Start/End dates overlap with a…
-
Moving rows from one sheet to another is not working
I have 2 sheets one where all the intakes are submitted to and a second one where all the complete intakes are moved to. i have an automated action that works fine. Then i notice some task were marked partially completed and they are not being moved even though they should be completed. I created a new automation action to…
-
Freeze Row
Enhancement request to add capability to freeze row (like freeze column)
-
IF, CONTAINS, NETDAYS, AND, CONTAINS
Hi all, Trying to use a formula to work out net days between events in a column (Visit End Date) when a second column (Visit Description) contains "V" but also only if the last visit also contains a V. =IF(CONTAINS("MV", [Monitor Visit Description]@row), NETDAYS([Monitor Visit End Date]1, [Monitor Visit End Date]2)) worked…
-
Operational issue due to new licensing restrictions - seeking ideas
Hello! I'm seeking ideas / work-arounds / the right language to convey the barriers and suggest enhancements in response to the new licensing restrictions. Here is my context. I used sheets to format a 'clinical trial transparency report card' (image below). This sheet curates institutional data from ClinicalTrials.gov…