-
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…
-
Import Data into SS Template I created
I created a SS template and in the template without data I can see my dropdowns and I assume my conditional formatting all work. When I import excel data it creates a new sheet and none of the dropdowns or conditional formatting are there. The conditional formatting is what I really want to be loaded from the template -…
-
Print row as a checkbox function
My organization uses smartsheet to keep track of daily logs of employee groups, the organization we have to submit those daily logs to uses Procore, where I have to manually go through and print each row as a PDF, save it to a Box folder, then upload it. My question is, can i use a checkbox to output a true/false…
-
Transfer/Copy workflows between smartsheets
Hello, Is it possible to copy workflows from one Smartsheet to another (similar) one ? Thanks. Regards 😊
