-
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
-
Find the row with the earliest Created (Entered) date that matches certain criteria
This one was a challenge. I thought I had it solved, but an erroneous value showed up, necessitating taking the formula back to the drawing board. The requirement: Show me the oldest Bill of Lading number that does not have a status of "Closed" or "Canceled." In another cell, show me the full Created date and time of that…
-
Published sheet not showing filters when embedded in a website using iFrame
I have a sheet that I have filters set up to display various tasks in the Cardview. When I publish the sheet and use the Embed Code, everything works as expected with the exception of the Filters. The filter button shows but none of the saved filters are available. If I try and create a filter while editing on the website…
-
Reference a contact in IF formula
I'm trying to return a value of "TRUE" in a tick box column if a contact referenced in the same row is a specific person. It's a multiple contacts column too but I've done dummy runs with only one contact and it still won't work. I've tried the following and they don't work, what am I doing wrong? 😞 =IF(CONTAINS("Joe…
-
Can a workflow on one sheet update specific empty cells on another sheet?
I have a sheet with a list of no longer needed items that may be useful to another group. I have setup a custom URL (custom per row/item using a unique asset number) that opens a form on a second sheet to gather the requestor's contact information. When that new row is created on the second sheet, can a workflow…
-
Workaround for all attachments sending in Update Requests...
Does anyone have a workaround for not wanting to show all the attachments for a row when an Update Request is sent with the option to attach a file? I am using Smartsheet to track RFPs and the information for each one is collected into one row on a Master Sheet using a form. This information will sometimes involve multiple…
