-
IF/AND - Red, Yellow Green Formula
Hello! I'm trying to reflect the contract status based on a contract expiration date. Example - If contract does not expire for 45+ days, status is green. If the contract expires within 15-45 days, the status is yellow. If the contract expires within 15 days, the status is red. Unfortunately, the status shows as yellow if…
-
What formula to use to change R,Y,G status?
I need a formula that will change the RYG status in the PO Status Column to yellow if the milestone complete column is unchecked on the date that is in the "End Date" column. Essentially, I want to automate the status. If the milestone is not marked complete by the end date, change the PO Status column from green to yellow.
-
Adding image to a form
I have a group of images to be used on a form, is there a way to add it to the form without uploading them, I thought I could copy and paste them, but it doesn't work. Below is part of the image. They are two of these, making 50 .
-
Automation actions across multiple sheets
Hi all, I have a client who prepares Smartsheet instances for clients of his own (I'll call them customers) in one very particular use-case. In an nutshell: The Cast: Sheet A, the core sheet Only my client's team can admin. New rows come into this sheet via form submitted by customer. Let's assume we have only three…
-
Dashboard Not Updating
Hello. I've inherited a Smartsheet Workplace that has a robust set of sheets and one dashboard. My question today deals with the dashboard not updating some of the widgets. To start, one widget in particular shows a basic line chart that pulls from a single sheet. The source sheet initially only had data (columns) for…
-
Calendar View (do not show child lines)
Hi, I have a Grid view which contains both parent lines and child lines. However, in the Calendar view I only want it to show select Parent Lines. I tried to lock the specific lines I want and filter from there but it is including all the child lines under the selected parent line still. I see there is an easy way to…
-
I cannot create a dashboard in my smartsheet folder.
Whenever I click create a dashboard - I am getting this notification. I have both sheet and reports in the same folder. I am not using a template but am trying to build a dashboard from scratch.
-
Dashboard is a blank screen
I am trying to create a dashboard, and when I click "Create", I either get an error message or the dashboard is created but the screen is blank. Any thoughts on why this is occurring?
-
Row Update Emails not sending
Hello, I am emailing row refresh requests to myself and am not recieving them. This start about an hour ago. I have tried restarting and have sent a dozen (all saying "Update Request Sent") but have received none in my inbox. How do I resolve this?
-
Copy of Original "Master" sheet
Hi there! Relatively new user here!! I have an active "master" sheet that I am taking over for a coworker who has moved on to a new role and I've made a copy of it to use as a sandbox while I continue to learn this software and wanted to know - If I publish my copy to test the additions I've made BEFORE adding to the…