-
Calculate cumulative duration of time spent in each status where status changes are bidirectional
Hi, I have a problem I am trying to solve in a sheet that contains hundreds of individual requests. Each request starts with Status = 'New' and finishes at Status = "Complete" in between there are 3 review statuses, "Review Department A", "Review Department B", "Review Department C" depending on the department the review…
-
Pricing: A La Carte Apps
Smartsheet, you need you allow apps to be added a la carte to Business accounts. Restricting apps to Enterprise is unnecessary. It feels like nothing more than hard-ball sales tactics. While Smartsheet has helped our business organize our operations team, we are not happy about the divide between Business and Enterprise…
-
Need help with building out a sheet based on days remaining in month
Hi All, I am working to convert an excel file into smartsheets and trying to figure out where to start here (this is something that I inherited and the original owner of this file isn't around anymore so I'm kind of reverse engineering this). This is what the excel file looks like: The formulas that I need to recreate are…
-
Finding Distinct Values in Two Columns
Hi, I was wondering if it was possible to find the number of distinct values in two columns. In this case I am looking to find if there is an overlap between start and completion dates for a given crew lead. Is there a reason that I am getting 1 as my output here? Is there any other way I can accomplish this?
-
Pinned Recently Opened now sorting by last opened and it is horrible
Today I saw that my pinned recently opened sheets and reports were now a jumble. I sorted them back out and as soon as I clicked one to open it zipped to the top. This change is not really welcome and I would love the option to change if these are sorted at all. Having an active list like I used to made many things much…
-
Report not updating after source sheet is edited and saved
Hi, I am trying to update a report but whenever the source sheet is updated and saved, those updates do not filter into the report. I have tried waiting to see if it just takes some time to update, refreshing both sheet and report, closing out of and reopening both sheet and report, but nothing seems to work. Additionally,…
-
Possible to send a identify verification SMS via DocuSign with Smartsheet?
I would like to send an attachment via Smartsheet/DocuSign API and set up already the template. But I can't figure out how to set up the mobile number in Smartsheet that the recipient can receive the identity verification SMS. Does anybody generated documents already and used the verification SMS?
-
Voting using Symbols Formula
I want to collect "votes" from multiple voters (columns Voter 1, Voter 2, Voter 3, Voter 4, Voter 5, Voter 6) using RYG Balls in a sheet. Each row represents an item that is received through a form that must be voted on. I have a "Tally Vote" column that I want to use as a summary of sorts to reflect status at a glance in…
-
Get the value with the latest Date
Hi Experts, I need help in getting the value from the item column of Test Sheet1 which has the latest date and put it in the test sheet 2. I am trying to use, join(collect(Item sheet1 , Date, max(Date(@cell)) but not working. Can you help me with the correct formula? And second question, what if I have 2 reference sheet…
-
Restricting multiple entry in Forms
Hi Everyone, Is there a way to restrict multiple entry in the forms? Or any way I can set the validity of the form for a particular duration? Regards, Abhiraj Joshi