-
Connecting two Smartsheets (one a set list of assets, the other freeform)
I am trying to connect two Smartsheets. This is my current setup: The first Smartsheet (Smartsheet A) contains a list of shared assets, designated by an alphanumerical ID. When an issue is identified in one of these assets, it's set up so that when someone clicks the flag button, it notifies others. The second Smartsheet…
-
Multi selection form into single rows
Hi all, I have a form that allows multiple selections. Once the form is submitted I need the each selection to be added as a new row. I have several issues: -Selection list extensive (50+) therefore cannot be written as separated columns as suggested earlier. -Users will have a hard time to submit a form for each item and…
-
Assistance needed with the following formula...
I'm trying to put the correct data (person) in the correct column for an Employee and their Management hierarchy, using the following formula: =IF(VLOOKUP(Worker@row, {Active Workers Report - Mgmt Lvl}, 5, false) = "Team Lead", {Manager}, "") Can someone help me correct the formula, so the Name of the Team…
-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Duplicating a Report Sheet in Smartsheet
Hello. I have a report, and I want to use the same settings / filters on the report page but for different projects, so I "saved as new" and renamed it at the top, BUT, how do I clear it out so there's no existing information entered that's on the original report? ( I hope that made sense ) - any help or suggestions are…
-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
-
Sheet Summary Formula
Hello- I am trying to get a formula to display a certain cell- Hours Available in Week when the Team Member is Jaclyn and the Week Number is 22. I keep trying the formula below: =INDEX(COLLECT([Hours Available in Week]:[Hours Available in Week], [Team Member]:[Team Member], "Jaclyn Light", [Week Number]:[Week Number], 22),…
-
Start Date Formulas not appearing in reports
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
-
Countif for Days Elapsed between two dates
Hi - I have a tracking sheet - it logs date when we receive a request and then a date when the request is fulfilled. I need to calculate how many rows in my sheet where the date rec'd to date of completion is 5 days or less - I'm doing this in a Sheet Summary field. I asked the AI for a formula and it gave me this:…
-
Formula to insert date and/or time
Hi All, Whilst I use a 3rd party app for shortcuts when typing, its fully functional in Smartsheet. I am seeking the formula to insert the date in a text field while typing. Example in MS Excel the formula is &[Date] however this doesn't work in Smartsheet. I use Smartsheet via Microsoft Edge.