-
Issue with Update Request Automation
I have a task list for myself where I have an update request automation set to run based on due date. I have had this sheet for a couple of years with no real issues. I only receive notifications within SmartSheet and don't have them emailed to me. Beginning last week, anytime I open the notification for this particular…
-
How do companies manage and document data flows in Smartsheet to ensure data integrity?
I’m new to Smartsheet and data meshing, and I’ve noticed that the original source data isn't always used consistently. For instance, someone might create a data mesh from a source to build their own sheet (Sheet B). Then, another person creates a data mesh from Sheet B, and this process continues. How do companies manage…
-
Transfer specific row data to another sheet when a checkbox or drop down menu item chosen.
In short, I would like to have a menu item or checkbox in one form that when checked it sends certain specific cells on said sheet to another sheet. Can I tackle this with an automation?
-
Calendar View from Sheet
On the calendar view in smartsheet, is there a way to show more information than just what is entered into the primary column? For example, we have appointments that need to show who the meetings are with, who's invited, and the time and location at a glance on the calendar view, without having to click on the appointment.…
-
Report not showing certain columns
This discussion was created from comments split from: report not showing all columns from a sheet.
-
How do I apply conditional formatting to a single cell?
Hello, How do I apply conditional formatting to a specific cell? For the example below, when I click on the "B/C" check box, I only want to highlight the B/C within that row and not that column. Wasn't sure of the best way to do this.
-
Purchase Order form with multiple line options
I'm creating a Smartsheet grid with form that will generate a purchase order. There will be an option to add 9 different lines to the PO. Each line has its own variables: Quantity, Unit, Unit Cost, and Description. I added a question "do you have additional items to add to this PO" as a column with logic to have it either…
-
Sign up form limit how many times a drop down value can be chosen possible?
Hi, im trying to create a sign up sheet for an event through smartsheet form. is there a way to restrict how many times a value in a drop down can be selected? for example, if my sign up sheet ask user to sign up to a certain date and time slot, i would want to restrict how many times a particular dat and time slot (value…
-
Setting up Timesheets
Hi, what is the best way of setting up Timesheets on Smartsheet. I have tried a few different ways, but none of them work how I want it. Engineers will submit a timesheet once a week covering 5 days - 5 different hours to submit inc overtime - possibly including 5 different projects to allocate to. I was going to do this…
-
Editing a date item is not in the same format as the column format
Hi, Most of the time I use a different date format than the standard US default. When I edit a cell that contains a date, it is converted first to the default format. This makes it difficult to make small adjustment manually because the day, month and year is in a different order than what I see all around. See this…
