-
highlight today's date
I've just begun using SmartSheet and like it a lot, but it seems as though my team and I keep running into the same problem in various contexts when using Gantt view. Specifically: It's hard to find today's date. Every time we open a sheet, we first need to make sure we KNOW today's date, and then we spend a couple of…
-
Automated Update Request Form Changes
I have created an automated workflow, using the Request Update step. This automatically creates the form to send to the user to update. I would like to change the way the form appears and allow multiple line entries. When I go into Forms, that form is not there to update. How do I update the automatically generated form?…
-
Cells turning "yellow" automatically
I noticed that if I enter a new comment using the little text bubble icon in a row, that cell turns yellow automatically. Why would this be?
-
Re-Title Notification Header
I recently used one of the existing templates "Contract Management" under the Client and Customers in the Solution Center, and it worked great. However, When my users get a notification the header still shows the old name (see attached). Please let me know how to make this change.
-
AverageIF help
I need help with an AverageIF formula. SmartSheet support gave me this formula for help: =AVERAGEIF([Column6]1:[Column6]22, >0). Essentially, I want the formula to give me the average of the numbers in the Time-to-Fill (Working Days) column BUT ONLY if they list Human Resources in the Department column. I wrote this…
-
Status change and day counter
Hi all, Is there a formula I can use so that when I change a status in one of the columns, a day counter in another column returns to 1 and starts counting? For example, if I have an entity in "processing" and in another column the number of days it has been in that status, when I change it from "processing" to "complete"…
-
Can a Report Display Project Dependencies?
Hi, I created a grid, with each row in the grid representing an individual project. I set the predecessors between the various rows, so Smartsheet draws the links between the various projects. I need to show this grid, including links between projects, on a dashboard. So I created a report using the grid as the source, but…
-
Show Conditional Formatting/Cell format on Automated Alerts
I have built an automated alert that determines which columns to include from a large Smartsheet which uses the max 200 columns based on a number of parameters held within certain rows on the sheet. This works well. However the issue I have is that I have conditional formatting contained within certain columns in the…
-
Automate RYG Balls based on 3 columns.
Hi, I need help with finding a way to automate the RYG balls so that if no dates are input, it's white. If the first date is input, it's red. If the second date is input, its yellow. And if the final date is input, it's green. Thank you !
-
Report based on specific text in a cell
Hello, I have a data sheet used for a call log for project issues. I'd like to be able to run a report that displays all calls for a specific serial number based on which serial number is entered into a cell, a variable search value. Ideally, I would have a dashboard with a web content widget that would be looking at a…
