-
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…
-
Looking for Smartsheet cheat sheets and/or packaged training material
Hi, I am the project manager across a number of projects and we are onboarding users to Smartsheet so that they can use what templates that we have developed. In some cases, this is senior leadership who just want to have the basics, all the way to team members that will be updating material. I am in healthcare, so they…
-
Resource Allocation
Hello Smartsheet Team, I have been using Smartsheet for over a year now and my organization benefits greatly from Smartsheet functions! However, resource allocation is something that prevents us from moving forward with Smartsheet fully. There are 2 things that we struggle with: 1. Lack of option of flexibility in the…
-
Tracking Employee Training and Certifications
Hello! We are trying to find the best way to track employee training and certifications categorized by department and type of position. Has anyone been working on anything similar that they could share? TiA!
