-
Index Collect Formula Showing #Invalid Value
I've been searching around and my formula looks correct. I even saw on a previous discussion that you should erase the formula and then log out and log back into Smartsheet and maybe that will help (unfortunately it didn't for me). I've also tried to make the formula manually multiple times. The only thing I can think of…
-
Automated Reminder for Approval Request?
Hello, Is there an easy way to send an automated reminder based on an approval request? We automate approvals from some of our Smartsheets and would love for a reminder to be sent x days later if the approval status is still "Submitted". I can't find where I can build a reminder based on the status change plus a number of…
-
What formula do I use?
I have 2 sheets. Sheet one is a grading sheet that goes over appearance, aroma, feel ect. of a production lot. Sheet two is a stock list showing all production lots. Both sheets have the primary column set at Ample number (ID #'s). I want to use a formula in sheet two that copies the final grade from sheet one if the…
-
Syncing multiple Smartsheets into one master sheet
Hi, I've got multiple sheets for individual projects that I wish to collate into a master sheet. The sync needs to be two-way, so if you update a row on an individual sheet it also updates on the master and vice versa. I'm currently achieving this using Unito, but it's getting super expensive so I'm hoping there's a way I…
-
Combine two rows based on a unique identifier?
So my smartsheet randomly receives two entries with the same unique identifier with different rows filled out. For example, my smartsheet has the columns "machine", "material", and "program". entry 1 has the identifier xyz and fills out the "machine" and "material" columns. entry 2 has the identifier xyz and fills out the…
-
What is your method for creating recurring tasks?
I have a Task List sheet which is pretty standard stuff. Task Name, Due Date, Assigned To. But we create some tasks that are a recurrence, like, "Check on Person A Every Two Days." Obviously, I can manually (using a formula to increment my dates =WORKDAY([Due Date]5, 2)) create a bunch of tasks out into the future, and…
-
Formula help
Need to get a specific average from one column to another Start with Association Name column with specific name (value for Marina Isles and Pelican Sound separately) Tied to Issue Category for a specific issue Then average it out against and manually entered number. For example Marina Isles has had 3 driveways issues that…
-
Why am I unable to run a particular workflow on a weekly basis?
Is it because it's referring to a date field? There are sometimes as many as 20 changes in a day as renewals occur in batches so I'm trying to avoid getting an email for each row where the renewal date changes. Thanks!
-
Updating the Red,Green,Yellow Status Column based on Dates from End date Column
I'm trying to create a formula that changes my status column to the red, yellow, red symbols. I want to base it on my end date column. I looked at some examples on the site, but i couldn't quite get it to work on my sheet. I was trying to set up a formula around the following parameters. Red= Past End Date Yellow= Within…
-
help with sum if
I am hoping to sum up the amount in the P&I Amount Colum if the Status Colum is Confirmed or Needs Org Profile Updates, or Summited (under review), or etc. in the Total Approved cell row 43 and column P&I Amount. I think it is a sumif formula. The formula I currently have is =SUMIF(Status1:Status42, "Confirmed", [P&I…
