-
How do I return Last Match with VLOOKUP
Hello, My VLOOKUP function is always returning the first match other than the last match. The lookup table is updated chronologically, and I need to return the most recent data which will always be the last match. I'm open to other solutions that use other functions. Thanks.
-
Identifying trends with =countif?
I have a drop down list of about five hundred items that my four vendors can select from. I'm trying to track trends of frequent selections, such as the top five things + how many times it's been selected within 30 days + who has selected what. I've used =COUNTIFS(Item:Item, "item name", Date:Date, >=TODAY(-30)) in the…
-
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…
-
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…
