- Weather icon on calendar view
I have been using smartsheet for several years, and I would love to see on calendar view a weather icon for, al least, one week. Just like Microsoft Calendar. My projects depends on weather, so its pretty important knowing the forecast.
- Will Dashboard editing every include an 'undo' function?
Hi, it's very frustrating when editing text in a widget, that you can't undo. Hoping this is on a list of improvements. Thanks, Louis
- Automated Update Requests
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. Thanks !
- Column Number Function
你好有一个函数可以返回the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
- Auto populate data and allow customers to update
Hi! I work for a membership based trade association and I'm trying to build a form that would allow me to share profile information on file with our customers (member companies) and then allow them to update outdated information. For example, I would auto populate contact information, # of employees, etc. and they would…
- Workflow automation - update requests
Hi, I need help. I have a workflow to send an automatic update request when a deadline is achived. The workflow is working perfect but I would like to send line by line and not all lines in same request. Anyone can help me to solve this? In addition i would like also to send an automatic e-mail when the first request is…
- Update Request does not allow editing field
I have a workflow that sends an update request to each resource assigned. I'm trying to get them to update "% Complete", but it's showing as uneditable. The user is an Editor, and it does allow them to edit other fields, such as Task Name and Resource Name. The % Complete is not a locked column, and the row(s) are also not…
- Form Response Validation
How can I validate the format of responses? For example, I want phone numbers entered as 000.000.0000, so when a user enters their phone as 0000000000, or 000-000-0000, they will be shown an error message that directs them to enter it in the appropriate format. Also, is there any way to validate an email address?
- Having Issue with "COUNTIF" returns "0"
Hi Guys, I have to count the status. Let's assume I have 5 different statuses (0,1,2,3,4) in another sheet. I have prepared a separate metric sheet to count the status specifically for a date range but I got the result as "0" for everything. I have tried to change the name to execute but that doesn't work. can you please…
- Assigning Multiple Resources
I've seen posts going back 3 years that address this subject, and it's little mind blowing that a feature as basic and essential as this does not seem to be possible yet. My team works on multiple projects each day, and each project has at least three different team members assigned to it at once. Without the ability to…
