[email protected]’s Profile
Community member since January 2019
National Louis University
Is there a way to prevent a sheet from showing up in a search?
I have a handful of "behind the scenes" sheets that appear in the search when my team searches for something. Is there a way for a sheet not to appear in the search? (That is, just show the sheets that they will use, not the "behind the
I didn't see a solution to this anywhere, but I was wondering if there is an easy way to capture the approval date and put that date in another cell. I'd like to use this as a predecessor to another task, and if the approval is late, the other dates adjust.
I want approvers to easily see how their
Is there a way to send a reminder to someone who received an automated request for approval? I have program chairs who are either not responding or are not responding in a timely manner, so the Approval Status remains "Requested".
Right now, I reset the status so it triggers the automated request
Faculty can submit a request for a course copy via a Smartsheet form I created. In the form, they are required to enter the name of their Program Director/Chair.
If the name of the person requesting the course copy is different than the Program Director/Chair, I'd like to send an automatic request
How can I use MATCH to find if an instance occurs within a group of values joined with JOIN?
For example, if I join the values in three columns (Red Yellow Blue), no commas just a space, and I want to MATCH the value in a cell (say, "Red"), how can I see if the joined values (Red Yellow Blue)