-
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…
-
Is this functionality available in Forms?
I have a sheet of sheet of user information that I need to add to and want to be able to do so with a form. My hope is to be able to create form with a drop down that allows individuals to pick their name or email address from the drop down (that will correspond to the row on the sheet) and then they can complete the other…
-
Interlinked individual Sheets to Master sheets
Hi Experts, I need help. I have 6 individual sheets that I need to rows to combine inside one Master sheet and update/add rows automatically when the individual sheets gets updates. Is this possible? I know it is possible when we use report builder but I want my Master sheet into Sheet because I am going to make a Metric…
