-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
How do I create a report that sums totals from my sheet?
Hi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.
-
Webinar recording: Work seamlessly with Smartsheet and Microsoft 365 integrations
Missed the webinar? Watch the recording here: Work seamlessly with Smartsheet and Microsoft 365 integrations. Increase productivity and real-time collaboration with our Microsoft 365 integrations. In this webinar, we'll share how your organization can streamline work across Smartsheet and Microsoft products, including…
-
How can i use symbols of 4 different colors for the following scenarios?
could you help me please? There are 2 parts; part 1; contract notice period, part 2; contract expiry time for part1; If the day remaining until the notice of termination is over 60 days; Green If it is between 60 - 15 days; blue If between 15 and the termination notice period; Yellow If the notice period for termination…
-
Free Webinar: Intro to Data Shuttle
Join us on September 16 for our webinar Intro to Data Shuttle where we will be discussing how we can leverage Data Shuttle to automatically and seamlessly upload or offload data between Smartsheet and other tools you use.
-
Averageif and match for summary of info
I'm trying to average the the percent of submissions for an assignment on one Smartsheet based on a teachers ID in the current sheet. Here's the formula I've tried =AVERAGEIF({Quiz 1 Completion Avg}, MATCH(ID@row, {ID })) The results that are populating in my sheet do not match with are not correct. We have one sheet (the…
-
Return unique values while ignoring blanks.
Hello! I'm trying to find a function similar to vlookup or index that will return a unique value where there are duplicate search values. In this example, individuals book a desk on a given date. Since form submissions create a new row, the bookings flow in like this: Sheet # 1 My goal is now to collect these bookings on a…
-
Return status of cell (blank vs. full) at today's date.
Hello! I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have a vacant/occupied indicator on a SS dashboard. My test sheet is below: So, to determine whether Desk 1 is occupied or…
-
Free Webinars: Smartsheet Advance
Join us for our upcoming webinar series where we’ll be introducing how Smartsheet Advance enables you to scale existing work, build more advanced solutions, and connect your Smartsheet work to other systems and platforms. We will be kicking off this series with a two-part webinar on June 24th. Part 1: Scale Projects and…
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
