-
Spreadsheet Filters vs Report Filters
I have a text column that has formulas and conditional formatting already added to it preventing me from changing the column type to a dropdown list. It is spread across several years of spreadsheets making a larger conversion to a list time consuming. I have a request for Report Filters to have the drop down list similar…
-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
-
produce a report.
Hello, ive been asked if we can produce a report with the percentage done column like the illustration shown below?
-
Modified Date and Conditional Formatting/Alerts
I have hit a problem that Smartsheet can't seem to deal with. My goal is to create a sheet that runs conditional formatting based on the differential between 'Modified date' and a TODAY equation. Firstly I tried to create a TODAY based formula in the conditional formatting tool. However, this acted as a figure once…
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…
-
Automated Alert & Action Issues
Hello I am trying to solve an issue with a system I have set up for Automated Alerts & Actions. See screenshots below. As you can see by screenshot 3, I have created a trigger column based on date surpassed; once that date is surpassed the cell will change from N to Y. The idea ultimately is when it changes to Y it…
-
Hyperlink
Is there a way to include a hyperlink in an update request when they open the update form button?
-
Auto reply to a form
I was wondering if there is a way to have someone reply automatically to a form when asked for a reply
-
Update via Update Request doesn't show my username in cell history
I CC'd myself on an Update Request to UserX. I used the link in the email copy I received to update the task because UserX informed me of his updates via email. After I made the updates using the link in the Update Request email, the cell history in the smartsheet shows that the updates were made by UserX instead of me. Is…
-
Is it possible to make reusable update requests?
I have communicated with my team that they can only use Update Requests once when they complete a task. However, I think it would be nice to be able to have an option to reuse them. If this is an option that I'm just not aware of, could someone guide me? Thanks
