-
Ever invented or thought about how to use Smartsheet for the holiday season?
Hi, Im curious about what the community has built or dreamt of building for holiday season needs? templates for sending /automating holiday cards? gift list and shopping? menu/party planning? santa list etc? Im interested in ideas to spread some help and joy via smartsheet this pending season.
-
Pulling email from other sheet when corresponding business name is entered
I have a sheet with the name of a business and the corresponding contact emails for each business. In another sheet, I would like for the name of the contact to populate when the corresponding business is entered on the same row. here's what I've tried... =IF([Name of Business]@row = {Recall Business Contacts final Range…
-
Calculate new start time for whole schedule
Hi there! As an event organizer, I want to automatically update my schedule in smartsheet when a session takes longer than expected. Column 1: Start Time (HH:MM) Column 2: End Time (HH:MM) Column 3: duration in minutes Column 4: new start time (HH:MM) how can I arrange a formula so that once entering a new start time in…
-
COUNTIFS with NOT CONTAINS from a Referenced sheet with two columns selected
Hello! I've searched through a few community posts but cannot seem to find an answer to my formula I'm trying to calculate how many products we have in one column that are not "done" from another column that are both being referenced from the same sheet where: {product} = Product1, Product2 {status} = Done, Ready for…
-
Multiple index/match nested in an If statement
Hello, I am having some issues with the following formula not returning the value I am expecting: =IF(CONTAINS([Raw Lot ID]@row, {ActiveRawLot}), (INDEX({ActiveQCResult}, MATCH([Raw Lot ID]@row, {ActiveRawLot}))), IF(CONTAINS([Raw Lot ID]@row, {ArchivedRawlot}), (INDEX({ArchivedQCResult}, MATCH([Raw Lot ID]@row,…
-
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…