-
Referencing sheets
I am trying to decide between one sheet vs multiple sheets. I currently have one sheet but it has over 50-60 columns and there are sets of data that will be used by different areas. I know I can filter what is needed (to a point) with reports but it still doesn't give me the end result I need. Here is the breakdown in a…
-
Grabbing excel fields and displaying value in a smartsheet field
I'm trying to figure this out.... I have 100's of excel files that are not formatted in rows and columns but these excel files all have the same fields and headers configured like a report. I want to "connect" these cells of each of the files to populate a row with columns representing the fields of the excel field name.…
-
Include update request button on Alerts
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
-
Clock Hour Progress Management
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not looking for a time management system, just a tool to enter a student’s hours into a spreadsheet or software to help me manage…
-
Looking for form creator - most secure and customizable
I've played with Google forms but don't like it's lack of customization and am not sure about the security. Are there other programs that are more secure that integrate with Smartsheet?
-
ical sync update
Hi, I am trying to sync outlook calendar using ical feature. However, the updates that I am making in smartsheet calendar is not exported correctly. There seems to be bit of delay as ical is exporting old data from my smartsheet calendar. Can you please investigate?
-
Drop Down Menus
Hello, I have a drop-down menu with a few selections and I want the next cell over to have a text based on what is selected from the drop-down menu. Can this be done? So on cell B3 I selected 5, and I want the word Tom to populate on cell B4 based on that selection. Thank you!
-
Automation from 15 smartsheets to 1 Master sheet
I tried Zapier but ran into two issues. 1. all the sheets must be active all the time.. Zaps will not Zap unless a sheet is inactive. 2. I need the rows added to the master sheet added per division NOT at the top or bottom.. What am I missing? I know that I can copy and paste the rows which is ok.. Just wondering if the…
-
Revoke Sharing Access after certain number of days
Hi. Is there a way to automatically revoke sheet sharing access after a certain number of days (e.g. after 60 days)? We''d like to give a third party access to our file but only within a limited number of days but we want it automatically.
-
Sight - sharing via email a PDF version
Is there a way to share the sight the same way we are able to share a regular sheet? sending it via email in PDF format at a certain frequency rate (monthly, weekly etc)? Thank you Luiz