-
Template for employee time tracking, automated report for clients and accounts, and dashboard
Hello community members We work on several projects where we have to maintain timesheets for all employees. Is there a template that I can repurpose to enable my employees submit their work hours under different projects and have some kind of weekly and monthly reporting in place for clients and accounts? Some kind of…
-
Highlight GANTT columns
Hello all, I do have a GANT I'm using to plan some Project activities and we do deploy in PROD just once in a month. Is there a way to highlight the columns of a precise week (2nd or 4th) with a different color or something similar to make them stand out?
-
Can you use Conditional Formatting on a single cell in Smartsheet?
I am trying to set up a Conditional Format on only 1 cell in a Smartsheet. I can easily do this on a Row or a Column but I only want it to apply to one cell (eg. if this cell is not greater than $10000, Make it Red, If it is greater than, make it Green). I see no way to do this on a single cell and it highlights all the…
-
URL link in a workflow message with different link text
Hi, I can send a link in the workflow message using {{link}}. But what I'm looking for is to send a link where the clickable text is different from the link itself. For accessibility, it is painful to listen to a long link that does not make sense. So, the receiving end, it would as simple as: Roadmap or Dashboard but when…
-
Calendar View is in the past. Why???
Has anyone had this issue? When I look at the calendar view of one of my sheets, it defaults to February-March of 2021 instead of the current month. If so, how did you resolve it? So weird because the sheet was not created until 2022... Thanks in advance!
-
How to Design My Smartsheet App
I work for a Hospital and I am creating an application to track employee health details such as vaccinations, annual health reviews, health exams, etc. For example, employees are required to get a flu shot each year or a waiver. Employees also have to take certain tests when hired such as a chicken pox test and a color…
-
Need help with Form capabilities!
I am trying to create a temporary process for employees to submit time and expenses. There is a Entry Type Field that specifies which fields are displayed based on if it's a time or expense. For Time - I have logic set up that based on the date a new field will appear labeled as which day of the week corresponds to the…
-
MS Teams Smartsheet Login Issue
Hello, I have added the Smartsheet tab to my teams channel. It was working previously, but now when I click on the tab, there is a message from Smartsheet saying I need to login to my account to access this published item. I click the 'sign in' button, which opens a new tab in my web browser, but then it immediately closes…
-
Find Reports w/ Specific Filter Conditions (critera)
A user has created probably hundreds of separate reports with varying Filter Conditions. Now I have been asked to updated all reports with a filter Region / is one of / PN or RM and replace it with Region / is one of / MP Is there a way (a) to do this search and replace on a batch of reports at the same time? Preferably…
-
Summary Field Properties - Symbols
Good Day, I am using summary field to display a status based on a field. I only see specific symbols available for use. They work fine but I would like to be able to change the color of one of the dots. They are presently RYGB. Is there a means to change this?
