-
Dynamic Form Entry...
Hi there - I'm curious if there's a way to have the data entered via a form added to a specified sheet that's selected from a field... All the sheets would be created from a template. Example) --Select Job#-- ^(Drop-down menu that dynamically updates with all Sheet names contained inside a folder) --Select Part#--…
-
Stuck Sheet
We have a sheet which is locking up every time you open it. If we have it open, you cannot click on any other sheet or the home icon to get to another sheet or workspace. We have found that we can right-click another sheet and open in a new tab, but it is very inconvenient and this is the only sheet that is doing this. Any…
-
multiple admins using filter feature at same time
As with Excel, you have the function to share a workbook or sheet and each user can filter without impacting another user in the same sheet making updates to their information. Does Smartsheet not have this feature that would allow 3 admins of a shared sheet, make their changes or use their own filters to do there updates…
-
Is there a way for a form in one sheet to populates a column in a different sheet?
I am looking to create a sheet that tracks who has viewed the monthly update videos on our company site. Ideally I would create a form that modifies the row, but I've read this is not possible. My idea for a work around is to create a sheet every month that has a form that asks for their employee number after they watch…
-
Sheet summary can be added to a report
I have created a report from 3 different smartsheets to merge it in a single sheet report. This report shows in a single view all our Purchase Orders from 3 different line of business Now I'm creating a dashboard to show quarterly trends (i.e. # requisitions submitted, # of requisitions completed and total requisitions…
-
How to create metric from timestamp in sheet
I am trying to create a metric in my dashboard that shows the average time of day that each contact submitted their request. The specific date is not relevant. Please help Thanks!
-
Trying to set up an Approval Workflow that triggers a cascade of Update Requests based on check box
Here's my vision: Someone submits information via a Smartsheet Form This adds a Row of data (30 fields) This triggers a "Request an approval" email to [Contact in a Cell] Contact receives an email with "View Request" button, to either Approve or Decline the data in that Row. When they click "Approve" it triggers a "Request…
-
Limiting Characters in a Cell/Date Validation
I want to limit the number of characters that a requester can enter into a cell via a form. The use case is that the user is entering a new request for consideration into an Intake Form. In assigning a name to their project request, we want to limit them to no more than 25 characters, based on limitations from another…
-
Can licenced/unlicensed editors view hidden columns
Hi, We are trying to share a sheet with hidden confidential columns to currently unlicensed collaborators. Can they view hidden columns as editors? I think the answer is that they are not able to view hidden columns as unlicensed collaborators but I want to confirm before sharing; and check on how/if this would change if…
-
Date updating to Next Day using Index, Match, Max, Collect Formula
Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries with a date/time (Created) and by whom (Created By). I'm curious about the cell surrounded…
