-
Cells turning "yellow" automatically
I noticed that if I enter a new comment using the little text bubble icon in a row, that cell turns yellow automatically. Why would this be?
-
Immediate Auto-Save
I'm trying to implement a solution for a team that needs changes automatically and immediately saved so the rest of the team can see the changes without delay. Is there a way to set each user's auto-save to immediate, rather than the current 1 minute? Or is there another suggestion for how to setup the sheet so that the…
-
Changing linked Google Drive file names
We have a substantial amount of Google Drive files linked (not attached) in our grids and have encountered a situation where we honestly need to rename them, rename some folders, and move others around - what's the best way to handle a situation like this without fouling up the links?
-
Forwarding Approval Requests
Hi All, I am developing a system that involves a large workflow of approvals. I have it set up so that the user selects a person for each approval to go to. However, I want to be able to have the person who receives the approval, be able to defer the approval to a superior if it is necessary. I found that forwarding an…
-
Custom Formulas or build in formulas for symbol to value conversion
We are currently evaluation Smartsheets (and others) for our team. Smartsheets feels very intuitive. The one thing I like are the symbols for completion e.g. the bar or the pie symbol, but then I'm struggling to use those in formulas. E.g. I use the bar symbol but now want to get to the overall progress for a parent task.…
-
Does SmartSheet Allow User tracking similar to Google Analytics?
We would like to track the usage of Dashboards, Forms and sheets if it is possible similar to Google Analytics?
-
Request help using INDEX MATCH
I'm trying to identify conflicting dates and locations for assets. The assets are entered into the sheet as new rows from a form. There are two columns: [Scheduled Arrival Date] and [Arrival Wet Slip]. I'm trying to use INDEX MATCH to identify when an asset's [Scheduled Arrival Date] and [Arrival Wet Slip] conflict with…
-
Created a new sheet. Wont show up when I search it
I created a new sheet. it shows up in my recent files, but when I use the search bar to search it, it doesn't show up. I checked my total sheets threshold. I am well beneath my 700 sheets. Any help would be greatly appreciated! Thanks,
-
How do I reference a Report Summary Field into a formula
I created a Sheet Summary Report for one of my Sheets. The Sheet Summary Report is grouping by JOB NAME and giving me MAX values for certain criteria I have a metric that is calculating a RATE and I do not want the MAX value of this rate in my sheet I only want the rate for the row in my sheet that has the 2 MAX values.…
-
Same subtasks for all projects..
Hi all, I'm new here, so sorry if the question's been asked before and I couldn't find the answer, but: I work on multiple projects at once, and they typically have the same group of tasks for each (I work in communications, and for every event (/project) I draft the same suite of products, and they get approved in the…