-
Record a date automation not working?
I have a task list, and I want to use automation to supply the date the checkbox gets checked. Here is my workflow: Am I misunderstanding this workflow? Do I need another condition in there somewhere? Absolutely nothing happens in this sheet when I check the boxes. Thanks!
-
Can I use VLOOKUP to find exceptions in a file and MATCH on those exceptions?
I have 2 tables: Source table - Data the is pulled in weekly (automated export) Destination Table - Takes Data from Source - using INDEX / MATCH data to find common ID NUMBERS between the tables. To get the common ID NUMBERS to match, once the weekly export is added to the SOURCE file, I search and find the new ID NUMBERS…
-
One sheet populating a master sheet.
Is it possible for one sheet be filled in with information then once saved, it will auto populate the same information onto another sheet (the master sheet)? For example, master sheet is called "Fruits". 10 people are assigned to a different fruit. One person has their own smartsheet called "Apples" another person has a…
-
Inquiry for use
Hello, In the case of pro plan, can't the share recipient (as admin) attach files to the row? thank you
-
How can I have a form that auto-fills multiple fields based on the information entered in one field
I have a Smartsheet that contains multiple lines, each starting with an auto-generated ID. When the user enters and existing ID in the form, I want some fields to be auto-populated with the contents of the row that starts with that ID. In other words, a vlookup that will return the information from the row in the sheet and…
-
CAPTCHA is reuqested, but form setting does not require it
In a form we are using the setting for CAPTCHA is switched OFF. But still some users report that CAPTCHA is requested before they can submit the form. Does anybody experience similar problems and knows a fix for this? Kind regards, Carsten
-
Time entry form
Hello, we have a sheet for our trades to track their time. We have one user who can't enter time in half hour increments when filling out the form. He seems to be the only one with this issue, everyone else can enter in 0.5 increments. We have it set as a text/number for the column type and display as a single line text…
-
Underlying row sort logic
Can you help me understand the underlying logic of how the rows are sorted and why it changes? My understanding was that the rows were supposed to stay sorted once we saved the sheet until someone else changes it, but that's not the case. I'll be messing around in the sheet in the middle of the night when no one else is…
-
Share a report with a collaborator that is not shared with the underlying sheet
Hello, I am in need of sharing a report from an underlying sheet, however the user I would like to share it with is not shared to the sheet. Besides sharing the sheet or creating a new sheet, how I can share the report? Thanks, Lara Lehnerz
-
Copying data from Summary Sheet to another sheet
Hi, We use the summary sheet of project plans for PMs to update the overall RAG and add any specific comments about the project and it gets pulled to Dashboard for reporting. However, I am also trying to create a repository of "overall status RAG" to observe if there is a trend over the life of the project. To do this, I…
