-
Update Requests 'Today'
Hi, I have a planned date column, and I would like to send out an update request to the contact column when the planned date is = to today. Is this possible? Thanks, Aaron
-
Ctrl F result is hard to see when a whole column is selected (almost impossible)
Guys can you just make the cell that gets highlighted when you use ctrl F while having a column selected a little more visible? Actually you can just put the marquee around it. whenever i do a search using ctrl F with a whole column selected, I am baffled by the low visibility highlight that the cell gets. When you do ctrl…
-
Who did what and when? - users stats
Hi, In this time where management wants more hard evidence, as admin I also get more questions on how our organisation is using Smartsheet. Basically they are asking me: Who is doing what and when ... (and is it worth to continue the system) I find it hard to answer these questions - maybe I overlook possibilities that…
-
Creating Different Update Request Formats
I send update requests every day. However, when I send them, I have to keep removing some of the columns as those that I remove are not necessary for the person to see. Is there a way that I can save an update request format with those columns removed so I can quickly choose the right formats for the specific person I am…
-
Transferring ownership of workspaces
Hi I have been assisting a client in setting up a workspace containing folders, sheets and reports. I have joined them into my team account for this purpose. Now they are ready to continue on their own and are setting up their own Smartsheet account. How do I transfer the ownership of this workspace to them so they are no…
-
Creating a Task when a new row is created?
Hello, I have a shared SmartSheet for tracking projects. When a new project is added to the project tracking sheet (a new row) I'd like the sheet assign a task to create the project in our project time tracking application. Is there some way to program blank rows to trigger a task when information is added to the blank row…
-
Nesting Formulas
Hello Smartsheet Community, I have a formula in Smartsheet that works: =IF(ISERROR(MATCH(5, [Risk Rating]3:[Risk Rating]19, 0)),IF(ISERROR(MATCH("HIGH RISK", HIGH23:HIGH25, 0)), IF(MEDIUM26 > 935, IF(ISERROR(MATCH(5, [Risk Rating]17, 0)), "HIGH RISK", "VERY HIGH RISK"), IF(MEDIUM26 > 310, "MEDIUM RISK", "LOW…
-
Calculate health of a smartsheet project.
I have created a smartsheet from a project management template. Start and Finish Dates, Durations, predecessor, % complete, are all working well. I can easily calculate the health of completed tasks by allowing a project manager to change the % complete and look at over all weighted averages of those complete tasks. That…
-
Cell Linking not working
Hello, Cell linking not working on some sheets. Works on most but importantly missing some links. This is cause serious issues. needs urgent attention. Anyone else experiencing this? Thanks Scott
-
Sights - Edit access
I'm looking for an option to have those that are not admins to update a Sights space from time to time. Is there a way to grant someone edit access for Sights without them being an admin?