-
Registration for Training Events
We use Smartsheet as a registration tool for our on-campus (now virtual) training events in Research Administration. Love it! Is there any way to limit the number of people who can register for an event? We're looking for an automatic way to cap the attendance without requiring someone to check the multiple sheets all the…
-
Dropdown list - Update from the dev team ?
Hi everyone, TL;DR : When will we be able to have dynamic dropdown for a column / field in a form? Is there a workaround? I can't think of a single project where this CAN'T be used... I'm using Smartsheet more and more to provide simple solutions to my clients regarding their work (finance, managing team, project...). I…
-
Merge data from one sheet into same document
Hi Is it possible to merge data (individual rows/cells) in the one sheet into the same Google Docs or Word document? Ie, get a list in a sheet (multiple rows of one column) to show in a document. Everything i have found so far, starts a new sheet for each row. Thanks Cheers Richard
-
Move Rows to Another Sheet...that contain formulas
Hello! Has anybody had experience trying to automatically move a row containing formulas to a new sheet? I am trying to pre-populate cells with formulas that would apply on a different sheet so that they will be ready to go once moved over during a workflow.
-
% complete on Gantt view
Hi there, I'm interested in adding the % complete option on Gantt view, like what is included in the Project Plan template. How do I associate % complete so that it shows visually in the bars? Thank you! Esperanza
-
Text/String Version of Max formula
I have a sheet where I am writing rows and not all entries will update each column. I want to reference that column on another sheet and only return the value that is not blank. I can't quite get the ISBLANK formula to work for this. I've done this with dates using =MAX(range). Not sure how to accomplish with text. Thanks…
-
Automated workflows in reports
I searched but didn’t seem to find the issue I’m having posted previously. I would like to set up automated alerts to individuals (contacts) based on a date triggered event however the base sheet has way, way more information than is necessary for those individuals to see. I have several reports that pull information from…
-
Autocomplete date range
Hi All, This is likely something quite straight forward that I'm over looking, but hoping someone may be able to advise - Still relativly new to smartsheets. I have a smartsheet, in which each row reports based on week numbers, such as the below formula. =COUNTIFS({Enquiry Tracker (V1) Range 4}, <=DATE(2020, 9, 6),…
-
How can I improve the efficiency of my sheet?
We are using a sheet to track a number of different measures which will provide a baseline for Q4 2020. These measures are tracked for a month, with detail and a RAG status being provided by a number of different people once a week from October 9th - 30th. At the moment, we have a separate column for each detail and RAG…
-
Sending Alerts to Contacts w/o Sharing
I have a sheet with information that is not confidential yet isn't information I want to share with all vendors. The managers who can view the sheet already need to see all of the information currently in the sheet. (As the owner, I have other information in columns hidden from other's views ) I set up alerts to go to…