-
I want to add a formula to my sheet where i can calculate the current month last working date
I want to add a formula to my sheet where i can calculate the current month last working date from the date entered as the last working date
-
Countif function with multiple conditions
Hi, I am attempting to set a counter wherby i reffernce my main sheet, checking if the department is Fleet, If the Urgency is High, and to only count if the status is EITHER In Progress, or Not Started, this gets rid of the completed tasks for my counter. Im using the below, refferencing a sheet "Front Door Requests", the…
-
Receiving #UNPARSEABLE error on simple If formula
I am checking a cell to see if it contains a name, If true, I want to return another cell value, if false blank.
-
Copy Row Automation working inconsistently
Hi everyone, I am new to Smartsheet (only a couple weeks), and I'm running into a problem when using the "copy row" automation. I use the same automation set up on different sheets to bring the data I need into a sheet I use for calculations. However, on some sheets the automation works and on other ones it doesn't. By…
-
Non-Conformance Template
Hi Everyone, This is my first post on Smartsheet. I am wondering if anybody has got a template to use for tracking internal and external non-conformances, which will then populate to a dashboard. Any input and advise will be appreciated Kind Regards Werner
-
Creating a Status Dashboard - Color-coded Widget help / ideas?
Hello all, I have an idea for a dashboard I am creating to have a simple status legend with drop-downs (green - on track, yellow - at risk type of thing). I created a sheet and report with the legend, so no issues there, but I am trying to figure out a way to reflect this on my dashboard. Ideally, I would want there to be…
-
Notification When Forms NOT Completed
I'm trying to set up a notification that goes to a manager each Monday morning informing him which technicians have not completed a vehicle inspection report the previous week. The link to the form is emailed to each technician Monday morning (eg April 15). They open the form, select their vehicle number from a dropdown…
-
Work Flow - Clone to another worksheet
I LOVE the work flows!!! But I have 15 facilities and 15 of the same worksheets. Is it possible to: 1. Clone the work flow from one worksheet to another or 2. print the work flow so i can enter the same verbiage & flow in all the sheets. While I am here - is it possible to send an Update Request WITH an attachment? thanks!
-
Bulk remove the " linked Cells"
Is there a way to bulk remove “linked cells?” In testing out this feature, I now have the blue & gray ‘arrows’ in a live file ?
-
Text Wrap Not Working in Primary Column
The primary column of my sheets are not wrapping text. I have turned it on and off, saving and reloading between each toggle, and verified that all of the reports into which the sheet feeds have wrapping properly applied. It is a problem on sheets I have created from scratch, those from templates, and ones that were shared…
