-
Did the report permissions get updated?
I had a report shared to other users as editor - cannot share. With this permission level, they were able to filter and sort the report but now they are not able to. Were the permission settings updated?
-
Searching from one sheet's range & search/match to another sheet's range for a unique identifier?
Hello, Is it possible to search from a range in one sheet and search/match it in a different range/another sheet? This has plagued me all day and therefore I can no longer remain clear headed about what the best course of action should be. I have two trackers in completely different departments; QC and PROD. I want to…
-
Merged: Group Management
This discussion has been merged.
-
Automation of responses from one form onto a second form?
I'm developing a skills competency checklist using 2 forms to collect info (1) self-assessment for staff to check-off skills and (2) Validation/Assessment from preceptor to check and sign-off that skills were validated. Is there a way to set up logic that auto populates responses from the first form onto the second form so…
-
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…