-
Is there an automated email notification for Forms?
I see that there is a box to check to get an email when a form is submitted. Is there any automated functionality coming that this would be automatic base on the user submitting the form without having to check the box? Not sure why it doesn't just automatically do this the extra step of the check box is cumbersome and if…
-
Printing Reports
There seems to be a disconnect between what appears on the screen of a report vs what gets printed. Has anyone found a work around on this? Specifically, we are trying to keep the groupings to remain on the printed version but when we got to print, it removes all of the groupings and just lists the rows out. We did find a…
-
delete a column from our sheet, what effect on dynamic view
Hi team, I hope you are doing well! In smartsheet, If I delete a column from our sheet, will it be automatically deleted in dynamic view and will it have some effect on dynamic view if I have used the column?
-
Moving Columns
Hello, I have a "completed" sheet that is the destination sheet for records that have been, you guessed it, completed. I would like to set up an automation that when rows are moved from that sheet copies certain columns to another sheet. The additional sheet is a template that we would use to upload into another system.…
-
Avoid automation sending same email to contact listed on multiple rows
I have set up a sheet that lists every web page on my company's site and has a column listing the Content Partner who is in charge of that page. I have a workflow that alerts the Content Partner annually to review their pages. Often, one Content Partner will be listed for multiple web pages in any given month (because they…
-
How do I fix the syntax in this formula to allow for a "convert to column formula"?
This is probably a really dumb question but I couldn't locate a debugging tool and I couldn't find anything in the land of Google, so now I am asking people way smarter than me :) My formula: =IF(AND($[Partner Type]$1 = "MSP", MSRP@row > 0), (MSRP@row * (1 - $[MSP Discount]$1)), IF(AND($[Partner Type]$1 = "VAR", MSRP@row >…
-
Formatting of Numbers scanned in to webform via barcode scanner
Hello Wondering if someone can help with the below scenario: I have a number of sheets with webforms that require team members to enter a SKU, some are used by the floor team entering expiry dates and they have the physical product in their hand and are able to scan the barcode. others are used by the purchasing team who…
-
Pulling in rows from existing sheets
Hi, completely new at this so please bear with me - I have been tagged or assigned to a couple of different sheets for project timelines. I would like to be able to find where I am tagged in column A, for example, and then bring in the associate data in other columns (eg, column B - project name, column C - task, column D…
-
Where are the phantom rows???
Hello Smartsheet Community. I searched this topic but found only variations of my specific issue. I have a simple smartsheet. 17 columns, 321 records. NO hierarchy, no attachements, nothing. Most columns are manual entry and about 4 columns are single-select entry. I have a phantom row that is presenting (not) itself in my…
-
Display Dates
Hi, Another question for you clever ones. I don't know if i'm missing something simple or not. I would like to display the weekends within a year on a grid but I want this to update itself yearly. So for example in January this year a column would display "2nd -3rd January" then "9th -10th January" in the next row down and…