-
Recurring Alerts
I have several dates per task that need alerts. I would like to send alerts once/week until they check done. I would also like to display the undone tasks for next 3 months on their dashboard. Once they are done, remove tasks from dashboard. Can you please help me with out to set this up? Example Chicago, IL Lease (Task) 1…
-
Referencing Ranges, is there a Range Manager like in Excel?
i referenced a range following the "Reference Another Sheet" option. But, one of my ranges changed its own name! It was Called "Carrier" and adopted another name somehow.. Now i keep getting an error that says the Name is already in use but i can't overwrite it is there a Range Manager like in Excel?
-
Smarsheets/JIRA Integration Question - not yet using JIRA Connector
I have a Smartsheets survey form that gets automatically sent out in a link via email when JIRA tickets in a specific project are closed. Our JIRA admin folks setup that automation, as we do not have the Smartsheets JIRA connector. The question is, when a new survey form is filled out, the entry loads into the Smartsheet,…
-
Maintaining template formatting on Dashboard
I have a dashboard I saved as a Template - when someone saves as new and uses that template as soon as they edit the widgets the formatting is lost. Is there a way to maintain the dashboard formatting creating in templates?
-
Selecting Columns in Match Function
I'm using the INDEX and MATCH functions. Can someone tell me how to select column headings for the Match Column function? When I try to reference the column headings row, the entire column gets selected. In Excel, MATCH only works by searching a single vector (row or column). Does MATCH in Smartsheet work differently?
-
Proofing Visualization
Using the Proofing function there does not appear to be a way to Conditionally format that column that would allow you on a Sheet view to visualize if the proofs for several rows are for example submitted "White" , Approved "Green", Rejected "Red". It appears you have to go into each item to see the status... is there a…
-
Need help
Hello, i need some help to set up my smartsheet document. Please check photo i attached, so i have those 2 vertical column, in one column i write all Colors i need which should be picked manually and in other vertical column ID it should automaticly write number for that color. Friend of mine told me it can be done by…
-
uploading pictures
Whenever I upload a picture into a specific cell, it displays correctly EVERY TIME (original orientation). When I click on the cell to open a larger view, the picture is always rotated 90deg. Any suggestions?
-
Automatically Check a Box upon entering a date
In my Smartsheet sheet, I'd like to enter a date in a column and it would automatically check a box in another column. FYI - I have a surveyor in the field entering a date of his survey and I have a Manager who just needs to know the survey took place, but doesn't want the date. Any advice is appreciated. Thanks,
-
Misbehaving Required fields in second submission of a form
Hello, Has anyone else noticed that if you have a form that allows for multiple submissions (reload form after submission) and if you have required fields on this form, they all turn red with the required field text to them as soon as you enter anything on this form? All you need to do is to enter the first field and tab…