-
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)
-
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…
-
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,…
-
Trial Version
I have used to full version of Smartsheet for many years, I have now joined a new company and downloaded the trial Smartsheet to show them how useful it would be but many functions are missing including wrap text and there is no capability to change the way the date is shown
-
URGENT - CAN'T CREATE NEW ROWS/CARDS
Hi, We wanted to report an issue we have been experiencing today with our files in Smartsheet. When trying to create new rows/cards through forms, the data did not seem to be saving — the files would load while filling out the form, but after submitting it was as if nothing had been done. After running further tests, we…