-
Any updates to "View permissions on individual columns & rows"
Hello, The original "View permissions on individual columns & rows" was posted in 2016. The end result appears to have been you could not set permissions for individual columns & rows on a sheet but the request was being noted as a possible enhancement. Has there been any movement on this? I currently have a "Main Sheet"…
-
Added IP Management Functionality
Any Chance of adding this type of Functionality to Smartsheets: https://www.codeproject.com/Articles/712335/Followup-DNS-Lookup-and-Ping-in-Excel
-
Can a Smartsheet form submitted auto-populate PDF then triggers DocuSign
Hi, I am trying to deploy a reimbursement system for my office. Once a person submits a form via smartsheet, I need to have a PDF pre-filled with all of the info including the ones that will be linked to other cells. Once the PDF is prefilled, I will need it to go thru DocuSign for signature. Once the user signs I will…
-
Removing duplicate types in an output report
I have a report that shows the output of staff within a department. It shows all the publications and events they are working on. I am looking to build the report so that it does not show duplicates of the same type of output by the same person. For example, Staff member A is running 10 roadshow events throughout the year.…
-
Archiving Meeting Minutes
We have to archive (over several years) and be able to search our meeting minutes for accreditation purposes. I can use the Meeting agenda sheet (Meeting Management set) for both agenda and minutes. How can I save the July agenda/minutes and create a new agenda/minutes sheet for the August meeting? Should I create a…
-
Help with formula (IF > AND > THEN)
Hi team, Could you kindly help me out with the formula syntax for the following scenario please: If the "Rag Status" column is 'Red', and the "Complete" checkbox is not checked, then the "Action Status" must change to 'Overdue'. Link to sheet is HERE.
-
Meeting/Projects in an academic environment
Hi, I'm chair of subcommittee that reports to the curriculum committee. My subc has monthly meetings, for which I need an agenda, minutes, and materials for the members to access and edit. A large part of our work is reviewing each required course in our curriculum (and there's a process for preparing materials and…
-
Default form date to Today + constant
I am creating a form that un licensed users will use to submit requests. I want the default for the form to be Today + 4 business days. Is this possible? It looks like the default date can either be hard coded to a specific date, or set to Today. Any help would be appreciated!
-
Using VLOOKUP to return a most recent date but with conditions
Hi there, I'm looking to pull off the following: * Smartsheet A is a list of stakeholders we regularly engage with. Every row is an individual stakeholder * Samrtsheet B is a tracker where we list the engagements themselves. Every row is an occasion where we have interacted with a stakeholder. We categorise these…
-
Reports Malfunction
Hi, Are reports malfunctioning with anyone else today? I thought I was doing something wrong until I read the past community posts suggesting prior issues with reports. /-RI