-
Retrieving Ancestor (date) value from multi-level parent-child rows
Hi All, I used the following formula to retrieve ancestor (first parent) date value of the multi-level parent-child rows for each row. =LEFT(INDEX(JOIN(ANCESTORS(Date@row), ","), 1), 8) The issue that I'm facing is the return value being "TEXT" despite having "DATE" column type. Since I have to use this return value in…
-
Looking to track cleanings
Currently I'm looking to add a validation mechanism to a sheet and would like to have a systems that reports after (X number of) cleanings have been completed for the day. This would add a row displaying the room that was complete for the day. If the room was not complete it would show up in red as not complete. I'd also…
-
Looking for ideas to improve my current daily process re: managing references
Hi all, This is a very open question to see if I can get ideas from the community to improve my daily morning process with Smartsheet. Apologies for the lengthy question- this is outside of my usual very specific help request. I'm responsible for our Company's data; in the property insurance- independent adjusting world.…
-
In Dynamic View, do Shared Users override Shared domains?
In Dynamic View Sharing, if a Shared User and a Shared domain are entered, and the Shared User's email address does not match the Shared domain, is that user still granted access?
-
Merged: Publish Reports for Editing
This discussion has been merged.
-
Sharing or Conversations, Attachments, Etc. side panels in the way? Temporary Fix.
I had a user at our company complain to me about the Sharing panel taking up too much real estate while on his laptop. He also expressed annoyance at being unable to hide the Conversations, Attachments, Etc. panel and having it stay hidden. I put together this simple Chrome Extension (works in the Edge browser too) that…
-
Sharing Two Linked Template Sheets
We are rolling out a new process dependent on two linked template sheets to be shared into workspaces for each new project. When we share the templates into a workspace today, it appears to retain the links back to the original template in our template workspace. Is it possible to share two templates together and have them…
-
Dashboard Sharing Outside the Organization
The people I want to share a dashboard with aren't really outside the organization but I ONLY want them to be able to see the dashboard...not have to log in or have access to anything else. I published it but it has a report on it and it says the report is not accessible on a published dashboard. What things can be shared?…
-
Teamwork and Smartsheet Integrations (Zapier?)
We currently use Teamwork for project management. Our account managers update their milestone dates in Teamwork to create their job schedules at the beginning of a project and then adjust the dates as it progresses. Our organization-wide job board is kept in Smartsheet and we run several reports from it (including monthly…
-
Notes Section for Rich Text Documents (Similar to Attachments)
Request: Add the ability to create editable rich text documents that are linked at the row or sheet level. Allow ability to have more than one document per row. Ability to track changes and lock the document from editing. Access would be similar to how conversations and attachments work: TL;DR: Sometimes information needs…