-
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…
-
Board View Group By not working for a drop-down column
We have 3 sheets that we use to track our sprints. Tasks get created on "1 - Backlog Planner" and when the two week sprint starts, automation moves the tasks to another sheet "2 - Current Sprint." When the task is complete, it gets sent to sheet "3 - Completed Sprints." On the completed sprint sheet, the Sprint Name is,…