-
Is amount of rows restricted in reports?
Hi, in my sheet I have about 800 damage incidents. In the corresponding report there is only 1 of 2 rows shown. Incidents after row 500 are not shown. Could that be? Is there a way to avoid this restriction?
-
Cannot log in Smartsheet
I have one free license user, she cannot access to Smartsheet with email link or weblink. Every time she trys, it goes to this page, with tag to "I agree to..." click continue, it will not respond. Even with click to "Smartsheet User Agreement", it goes to a new webpage with "log in", it will go back again to this page.…
-
Trying to fix the start date of a subtask with no dependency
I trying hard code the start of a sub-task (4th level indent). When I try the start dates always comes back to the start date of the task of the previous indent. I would like to have my sub-task with no dependency to start much later (hard code the start date). Any suggestions? Thanks
-
Workflow Automations
Hi All: I'm using Smartsheet to manage tasks within my department. When someone submits a new task, my team fills out the necessary columns and then flags a column called "Notify Owner of New Task" to trigger an alert to be sent to the task owner that they have been assigned a new task. I also want to notify existing task…
-
How do I restrict the range of dates in a Form input field?
I am building a reservation system and want to limit the days that a customer can select from in our Form. There are two versions on this - I want to restrict the input for the date field to only today and into the future, no days in the past. The other option I would like to do is to block certain days in the future that…
-
Looking for a User Profile Report....
Hello. I'm looking for a User Profile Report so I can make mass updates to our user base to reflect a new location and change in phone numbers. I don't see Profiles listed on the Reporting options in User Management; does anyone know of a way to do this?
-
Report Needed - Chooseable Columns/Fields
I am looking to create a very simple report where I can search all of Smartsheet for a particular customer and add columns to report on. For example, it would look something like... Customer Latest Update Next Steps XYZ Corp. Roof Installed Install Windows Can someone give me a quick and easy to follow guide to achieve…
-
Formula for tasks/Sheet Summary
So I'm at another roadblock so bare with me... I have a current formula that tracks the prior day's target tasks and a formula that tracks the prior day's completed tasks. However I want to incorporate my overdue tasks in these formulas as they still need to be accounted for. I was able to add my overdue tasks to my daily…
-
Nested If Or to control symbol
Hi All, I'm trying to set a symbol (Red, Yellow, Green) in a column based on the individual values in three columns. We'll call the columns the contain the values "Carrots Available", "Fudge Available". and "Veal Available" and the column with the symbol "Basket Status". If Carrots = 2, Fudge = 5, and Veal = 4 then the…
-
Automated Report generation on different field values
Is it possible to create an automatically generated report, say, that will run once a week, month, etc. that will pull date from all of SS (or only certain sheets) and look for 1-2 "customers" and several corresponding "customer numbers"? For example, there are several different customer numbers associated with a customer…
