-
Assistance needed with the following formula...
I'm trying to put the correct data (person) in the correct column for an Employee and their Management hierarchy, using the following formula: =IF(VLOOKUP(Worker@row, {Active Workers Report - Mgmt Lvl}, 5, false) = "Team Lead", {Manager}, "") Can someone help me correct the formula, so the Name of the Team…
-
Sheet automation notification email tracking using a PowerAutomate Flow and Outlook
This post details how to track all sheet automation notifications emails. This solution is medium complexity and will likely require you to use an AI for some simple coding. Smartsheet allows users to automatically send email notifications from sheets. There are a few significant problems with these automated emails.…
-
2 of 2: How to send Outlook emails using a template populated with Smartsheet data and triggering from Smartsheet
Continuation of 1 of 2 : How to send Outlook emails using a template populated with Smartsheet data and triggering from Smartsheet Details of how to send Outlook emails using a template that is populated with Smartsheet data and triggered in Smartsheet. This solution is complex. Some details have been blocked out for…
-
1 of 2 : How to send Outlook emails using a template populated with Smartsheet data and triggering from Smartsheet
Details of how to send Outlook emails using a template that is populated with Smartsheet data and triggered in Smartsheet. This solution is complex. Some details have been blocked out for privacy. I had to split this into two posts due to the length. 1 of 2 : How to send Outlook emails using a template populated with…
-
Countif for Days Elapsed between two dates
Hi - I have a tracking sheet - it logs date when we receive a request and then a date when the request is fulfilled. I need to calculate how many rows in my sheet where the date rec'd to date of completion is 5 days or less - I'm doing this in a Sheet Summary field. I asked the AI for a formula and it gave me this:…
-
Legacy Dropdown Functionality Option
Good afternoon, Recently there was a change that made searching a dropdown by typing inside of it switch from an exact match method where typing S would only show entries that begin with S to a search within method where typing S would show all results with the letter S in them. I can see how this would be beneficial in…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
Report for due dates
Hello! Does anyone know if there's a way to create a report for specific projects that reflect tasks that would be due on the same date? For instance, if several projects have the same due date, it will show up as such on the report so the manager would see this and due dates would not be overlooked. Any assistance is…
-
License versus Seat Members
The change from our 6 licenses to 25 members sheets has caused major disruption within our company. Previously, only the 6 licenses could create sheets, and ll other users could edit…. Now only member seats can edit and my 6 licenses is now 25 member seats. I previously had 40 users that had editing rights so they could…