-
Hide / Show Columns
It would be really nice if Unhide ALL wasn't the only option. I print info for several different people and some of the columns need to be seen by some but not all. I hide alot of columns so unhiding all just to change a couple is a total pain and alot of waisted time.
-
COUNTIFS with multiple conditions
Hi there- I have this formula built to count the number of projects completed within a certain date range: =COUNTIFS({Completion Date}, >DATE(2017, 7, 1) <= DATE(2018, 6, 30)) However, there are five different stages of a project: Completed, Under Construction, Approved, Under Investigation, and Cancelled. I would like to…
-
Adding New Rows
Hi, When adding a new row, I cant figure out the rule for indenting. Sometimes it will be correctly indented the same as the row above it. Sometimes it will add new row as a "Parent" and then automatically make everything below it the "Children" Is this caused by the way I'm inserting, or is there a default setting to make…
-
Saving Indented Row View
I love the Indent feature and especially the CHILDREN() function. Every time I save sheet or switch back from another sheet, my hidden indented rows completely expand & I have to re-click everything to find where I am. What am I missing to make sure the rows stay hidden until I need them? Thanks INB
-
tabs turn to dost/ellipses
Has anyone had an issue where the tabs within smartsheets turns to dots instead of having all the tabs at the top? It seems to happen periodically and I have no idea why, or how to switch it back to just have the tabs (I find the ellipses most annoying).
-
What the best way to manage 8,000 Projects in Smartsheet
I am new to Smartsheet and not sure how or if the program can help...I have project where I am rolling out a new program to 8,000+ locations and looking for way to leverage Smartsheet to manage. I know there is a 5K row so not sure how to proceed. Most threads talk about pulling rows out once complete but my project is a…
-
Random function
I'm looking for functionality that would enable a field to be completed with a random selection from a list. Is this something that exists within Smartsheet? I cannot seem to locate any formula code to accomplish this. In excel we would use a random integer nested in a VLOOKUP function that would generate a random number…
-
Update Requests
I created an update request for our staff to use when we receive subsidy payments. I have the update requests setup so only certain staff will receive the request. It was brought to my attention this morning that some staff are receiving the request who were not on my list for delivery. How is this happening and how can I…
-
Special formula help
Hi, I'm hoping smartsheet community can help me with an automatic formula. We have a column called "Priority Deal" this is a symbol selection of the stars, where we rate a specific land opportunity (empty/one/two/three/four/five) I'd like to create a formula when a specific star is selected, the column "Deadline Date" is…
-
Collaborating on Single Task with Outside Vendor (Rehab)
Greetings. I have a Real Estate Property "Rehab Project Plan" with tasks that I would like to assign to a vendor (i.e Electrician) so that I can manage his tasks and collaborate with him. I do not want the Electrician to see entire sheet, only that task(s) assigned to him. I have read several articles on this but couldn't…
