-
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
-
Display a counter in a bar graph
Hi community, I'm making a bar graph which shows information in %, so each bar is the percentage of the information I want to show, but this '%' comes from a scalar number which I also want to display. Is there a way to do this? I attach an example.
-
Course seat registration
Hi, I'm trying to set up a form for people to use to register for specific seats in specific courses. For instance, on the form, I should be able to select course A with my name and email . At that time, 1 seat from course A on the sheet should be populated with this data, and the number of available seats should reduce by…
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
