-
Auto Populate second sheet
Hi, I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so when a new entry is added through the form on the main sheet, a column is updated on the second sheet reflecting the new…
-
Filter not Working: Is not in the last (days)
Hello, I'm drawing a blank on why this filter is not working correctly. I process the archive of the data in this log and will archive every week the items that are 21 days or older. This is how I have my archive set up and it always returns items that were submitted today (which most certainly does not meet my filter…
-
recurring update requests
I setup a recurring update request workflow to send an update request out every other week on Monday Mornings at 10 am. It worked fine the first time around but it doesn't seem to work consistently. I assumed that every time it runs it goes through the sheet and finds all lines that match the criteria. Is that not what it…
-
Date Format
Hello, When I set the column type as "Date", I need to be able to choose different formats. For example, it currently defaults to MM/DD/YYYY, but I need the column to default to MM/YY or MM/YYYY. This data will then be pulled to another application (Domo), but it needs the correct format when being transferred over. How…
-
Automatically uncheck column based on date TODAY()
How can I get columns unchecked automatically when they meet a date criterion? For example, all tasks checked today will be automatically unchecked tomorrow because the calendar date has changed.
-
Capture Row history using API?
I am trying to build a UI using Google scripts to display the changes made to any given row. In other words, I want to capture a list of modified date, modified by and what was changed in a row if any cell in the row was updated.
-
Dashboards
Hi All - I am trying to create a dashboard to be shared with the team(s). Something with colors would be great! A list of all the projects and their status in a graph (or pie chart). Something with colors would be great! Any ideas?
-
Smartsheet for Inventory using QR codes
Hello everyone, I'm a teacher who has to manage a "MakerSpace" - a design studio with lots of electronic equipment. It would be ideal if I could place a QR code sticker on an object, take a snapshot of it with the camera on an ipad, and arrive at the inventory Smartsheet that I've created where this object's original…
-
Row Sharing
We use Smartsheet in our IT dept. for a few months now. 13 licensed people at this moment, especially to manage projects/tasks, in EMEA, China and US and we like to expand. Everyone was very enthusiastic in the first weeks, but the biggest problem is: row sharing. We work with external consultants a lot and we want them to…
-
Alerts to Microsoft Teams
When trying to set up an alert to Microsoft Teams from a Smartsheet Workflow I am getting the below permissions message. I have spoken to my Office 365 Admin and he is not sure what to do. Is there a link to an instruction on how to do this. This seems like it should be straightforward but I can't find anything.
