-
Capture the date a sheet was created
I have a sheet that I create for a review process - new sheet for each review. If the sheet is still open after 2 weeks, I want to do some actions - email the assignee etc. How do I capture the sheet creation date so I can add some automation? I know I can do this for cell dates but not sure about the actual sheet. Thanks.
-
Column border style
Hello! Just a simple idea that might be interesting for other users. When you have many columns with different categories, there is no simple way to make a visual distinction that allows you to "group" data vertically. So far, what I'm doing is to create a "fake" border using an empty column with background color. This has…
-
How can I use one sheet to build onto another and still be able to manipulate the data?
I am pretty new to Smartsheet, and my office would like to account for requests using Smartsheet. There are two types of requests: Original and Supplemental. Supplemental requests build onto original requests. Therefore, if someone wants to request the same individual, they will submit a supplemental request because an…
-
Automations when selecting from contact dropdown
I created an automation to move rows to a specific person when they are selected from a contact drop down. I have more of these to building, with different automations such as copy a row when they are selected from an other drop down. I also need to add a notification when each of these process have run. I attached what I…
-
Auto checkbox formula when cell contains multiple values
Hello! I am trying to create a formula that automatically check the box if the "Year upgrade or addition" cell contains the year 2012 or later. In my screenshot, you can see this cell contains the years 2007 and 2016. Since 2016 matches my criteria, I need the ADA Complaint? column to be checked. I tried =IF([Year upgrade…
-
Flagging a Date and Time Overlap
Hello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as many as 6 to 8 classes in a day, but only have 4 conference lines. I'm trying to write…
-
Recreating Report in a Sheet
Hello! Our team has a financial tracker and our timesheets in Smartsheet, and I am trying to find a way to link them. The goal is to take the number of hours worked on each project, and multiply them by our average rate to get a rough estimate of our current labor cost. Our reporting also needs to separate time between our…
-
pulling data from multiple columns at once
I have a master equipment sheet with different projects on it. I'm using a form to collect the information from the lightest orange fields because it's the easiest option for my auditors to use when they're in the field. I would like to get that information back to the original sheet. I know I can use an INDEX/MATCH…
-
Can I use a workflow to add a Funtion into a column based on other columns data?
This idea is to pull text from one column to another; examplet Below Primary Column: Country Names Child Primary Column: Secondary Project Workflow 1: When a new row is added, place formula to pull text from Child row into new column Workflow 2: When new column is added, place formula to pull data from Parent row into new…
-
Merged: Filters on Reports
This discussion has been merged.
