-
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…
-
I would like to combine 2 columns together when we send an email from a row
I was wondering if there is a way to combine 2 columns together when you send an actual email from a row to have everything on one line rather than 2?
-
Is it possible to filter out submissions from a form based on if the email field?
Hello, I am learning smartsheets and am unable to find a way to do this. We have a form for one of our sheets so people can submit requests to my team. However, we want the requests to only come from our organization. The form obviously has an option to only allow submissions if they have a smartsheets login but that…
-
Help with Totaling Against Options in Multi Select Drop Down in a Report?
Hello! Here is my scenario - I have a set up like this in my sheet (this is of course dummy data just to give a visual of the sheet structure) - I am trying to create a report grouped by the "Assigned To" so that I can summarize the # Hours each person is assigned, and then have a chart widget from that on a dashboard. I…
-
Parent Rows in Report
Hello, I have a made a current user report which shows only tasks where the current user needs to update. However I need the parent rows to show above the current user which may not be assigned to the same user. Is there any way to show parent rows in a report if there is filters that are applied which stop from parent…