I have several categories in my 'Status' column. (Sprint Backlog, Planning, In Progress, In Review, Changes, Print Files Ready, Print Req Sent, With Printing Services, Complete, Blocked) I would like to have a date automatically populate w…
What types, if any, of external input from other programs is SmartSheet capable of handling/using?
IE, is there a way to set up a sheet so that whenever a certain program updates its information your sheet does as well? If so, what types…
I'm new to Smartsheet and can't seem to find how an answer to this.
I've just located an Update request that has a pending status (found in smartsheet, not an email).
How do I actually action the request and change the status from pe…
A new user at my company inadvertently sent a license request. I can't find an option to delete it. Help?
Using Smartsheet41Laura Brady
I have a need for users when updating or entering data in a cell in a smartsheet that they must complete some mandatory fields. A webform has this function, however on existing rows it would be ideal to have users who are given updates or…
Archived 2015 Posts793Mark Bonham
UPDATE REQUEST to EXTERNAL Emails
We tried to send thousands of "Update Requests" to external email addresses using one Smartsheet as the source so that responses can be collated centrally.
This is to avoid …
I am testing a WF and I am not receiving the notifications via email like I thought I should be. I have attached screen shots of what I have set up. While I am testing the update request action, I am the specified recipient for e…
In regional settings, I can change the default date format for a particular region. I'm not able to find anywhere to change the default manually other than creating another column with a formula.
For example, I'd like to just have t…
has anyone come up with a creative way to combine a template with a cover letter? So example - we use smartsheet to gather requirements, we want to deliver those requirements to our customer at the end of the project in a polished package.…
Using Smartsheet61Jillian Tilley
Is it possible to set up an Automation / Workflow which will send a weekly reminder of any Update Requests that haven't been completed?
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 f…
Formulas and Functions797Brandon S
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…
We are moving from manual to to automated update request but it appears that the locked field functionality isn't working. When we send manually the fields are locked. In the automated request the locked fields are editable.
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&q…
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…
Using Smartsheet143Steve S
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 specifi…
Archived 2016 Posts31Anna Coombes
I'm looking for a clean, efficient way to handle multiple approvals for a row which contains comments without having a large number of columns. Up to 20-30 different people will be reviewing, sometimes 5+ for an individual row.
Using Smartsheet152Stephanie Wood
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…
Using Smartsheet41Mike Collins
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
API & Developers11Ezra
Hopefully someone can help, because I'm getting increasingly frustrated.
As a quick explanation, we have a huge Smartsheet that gets updated by several different departments on a quarterly basis. A webform gets sent out containing certain…
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 an…
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 informatio…
Formulas and Functions364Sarah_lee123
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…
Archived 2015 Posts274Dan Rasure
So, we send out quarterly update requests to various different departments...more specifically, to named individuals within those departments whose details are held within a Contacts column. These updates are timed so that they automatical…
Does anybody know if how to show on the same line of the Gantt mode, the expected planning and the reality.
Here attached is an example of what I need.
Thank you for your help !
API & Developers52T.Le Rendu - Dalkiawastenergy
Did I set up this alert to be too specific? I want to have an individual notified when a row to which they are assigned to has the status change to "In Progress". I'm trying to test it now but have doubts about the "In a row…
I want to send automated notifications to my employees containing their absence records.
To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their…
I'm having a lot of trouble joining cells that contain a certain value (because there is no contain function). I have a range of cells that are all in a single row, and I'm trying to collect all of the cells that contain a certai…
Formulas and Functions616erober01
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly revie…
Formulas and Functions31GWilkins86876
Is there a way to re-use an Update Request link? For example, if I opened an update request and I am not ready to post a response, is there a way to open the Update Request again? The Update Request link is a one-time only link right? Is t…
Archived 2016 Posts111Carlo Dimaandal