-
Workflow Approval Question
Hi everyone.. i have a pretty complex smartsheet and I'm using workflow approvals.. I have about 50 different columns, but there is conditional logic on the form - so when someone fills out the form.. sometimes they could only see lets say 5 columns (or field elements). The current automation I have is when the submitter…
-
Form sheet that gets cell linked to another summary sheet
I have a sheet that gets fed numbers from a form. The form will get filled out daily. I thought I had it all figured out-- I had the form add the newest entry row at the top and I linked those cells to my summary sheet. But then I realized that there was no way to make the linked cell link to an absolute row value, it…
-
Conditional Formatting
Hi - Trying to replicate this Excel Conditional format that runs based on a calculation off another column... So if Column A is less than 95% of Column B...light up Column A... Any guidance is appreciated...
-
I am trying to create a Dashboard that will collect Vendor expirations ... 60 Days, 30 Days, Expired
I do not know the formula to create the answers. Can anyone help?
-
Date Grouping for Gantt Dashboard
Hi Everyone, I'm trying to automate a sheet into a Gantt Dashboard, however I am having issues finding a work around to show the child and parent dates, as all the information is stored in one row, rather than 3 rows for example. Sample Column Names: Project Name, Task 1 Start Date, Task 1 End Date, Task 2 Start Date, Task…
-
Need row to turn yellow if date received is at least 2 days in the past
I need a way to turn a row yellow if the date received is at least two days in the past AND status is "bid complete", also turn red if date received is at least three days in the past and status is "bid complete". I would prefer if there was a way to do 48 hours and 72 hours but if not, days will work. I could not figure…
-
How to calculate a COUNTIF when using a date 01/01/2020 month to date
Good Morning Everyone, I am trying to create a formula that pulls from a master spreadsheet that calculates the number returned based on a date from the data sheet. I have columns that indicate month to date, September, August, July, June, May, April, March.... =COUNTIFS({LPSC tickets Range 1}, "Production", {LPSC tickets…
-
Form Submission Start of Shift
I have a form for the start of shift for operators. Safety inspection, 3s inspection, and other things they are supposed to do prior to starting their shift. For the location that I am attempting to implement this solution, we are running a 3 shift model.6am-2pm 2pm-10pm 10pm-6am I want to show a RYG for each shift if they…
-
Sum of multi select dropdown items with assigned values
I have a column (Design Software) formatted as Dropdown (multi select). The dropdown values are names of software products. I want to give a value to each software reflecting the respective cost (e.g., Adobe Substance = 3000, Browzwear vStitcher = 19000, etc.). I added the formula below in another column (Software Cost) to…
-
COUNTIF with NETWORKDAYS & TODAY - Counting Aging Orders in Sheet Summary Field
Hi Folks, I'm trying to set up sheet summary fields to count the number of orders of varying ages in a pending orders smartsheet. As far as I've been able to tell, there's no way to calculate it by hours, so I've settled for "order submitted today", 1 day old, 2 days old, 3+ days old. The problem is that I would like this…