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…
Cascading Form data sets is one of Smartsheet's missing capabilities that I believe would be a game-changer for many alternative providers. Cascading forms are a very effective technique that can be used to compress form data and limit down options in order to narrow a workflow or collect more accurate data. Recent usage…
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…
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 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?
This discussion has been merged.
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…
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…
I've noticed recently that workspace owners are not automatically made the sheet owner. Previously, I thought that if a sheet owner moved the document to a workspace outside of their ownership the sheet ownership would be transferred to the workspace owner. Is this not true anymore? Additionally, I've moved sheets to…
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?…