-
Auto Downfill?
Is there a way for smartsheet to implement an auto-downfill function that allows users to input their desired formula into a column heading that makes every cell within that column (including cells added in the future) populate with said formula? This can help users decrease their time entering formulas and allow ease of…
-
Product Suggestion - Admin Issues
This popped into my head as we have one of our licensed users who just refuses to share anything with any of us. What happens if they create a lot of important sheets that contain data and part ways with the company, how do we access this? The Super Admin should automatically have the ability to have access or a backup to…
-
Send Request for Approval Again
Hi: I have a column set up that an instructional designer changes as the status of a project changes, and I have another column that indicates the status of approval. When the ID changes the status of the development to "In Review", a trigger sends the Program Chair a request for approval. If approved, the ID can change…
-
Update Request to Multiple Recipients
I send an update request to 10 people. The request has the 10 recipients listed with text boxes under their names where they will each fill in data and SUBMIT it back to the SmartSheet. It works fine except when recipients go on vacation or are not available to answer the email update request. This holds up the entire…
-
Why can't I send a weekly update request for a whole sheet - not just a row / web form
I would like to send a regular Update request for a whole sheet - not just a row in a sheet. Alternatively I would like to be able to set an Alert to go out automatically every week / fortnight / day rather than according to a specific date. At the moment I have to set up individual alerts to go out every fortnight. which…
-
Send update request for all tasks not done for each assigned to user
I would like to send out a weekly update request for all "not done" tasks in a sheet, to all the users in the "assigned to" field. I can see how to easily do this with a workflow, but its sending all the "not done" tasks to the users. I want it to send only the task update requests for the tasks that that user is the…
-
Future Date Issues
I've noticed that some of the dates entered, if too far in the future will revert to last century. i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50 Also, once you enter the date as 01/05/2050 and it is shortened to 01/05/50, if you edit the date…
-
Alert Notifications
Hi I have set up a rule so that when a specific status changes to 'Required' the person assigned to the action gets and alert. We are only receiving a Smartsheet notification not an actual email. I have checked the account settings and we are set up for email notifications - any ideas what I am doing? Rs Abbie
-
Formula to automatically check a box when a certain cell is populated
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like a certain box to be…
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
