This discussion has been merged.
I like utilizing the row reports, however it would be useful if you could create calculated metrics based off of the summarized data.
I have a row report that I am building off of a sheet that includes the date, name, and time spent on a task. I am wanting to build a row report grouped by name, that summarizes the sum of the time spent on a task and the count of distinct dates. The part that I am struggling with is counting the distinct dates, as I only…
I have a master sheet that contains information submitted via a form. I am wanting to have a new sheet that contains only certain columns of information that populate as the data on the master sheet is entered. I only need specific columns of information, not every column in the row on the master sheet. Any ideas on how to…
I have an smartsheet "employee table" that contains employee names and employee IDs. I also have a smartsheet "activity" that logs employee activity via a smartsheet form. The goal is to pull the employee ID from the the "employee table" smartsheet and copy / input it into the Employee ID column of the "activity"…
I have a smartsheet that contains employee names and employee IDs. I would like to use the employee names stored in this sheet to update a form dropdown list of employee names on a separate smartsheet that tracks employee activity. I was going to use data shuttle, however there is not an upload data from a smartsheet…
I am trying to use logic in my form, for example I know that I can do 'if field fruit is apple then show field grocery' however I was wondering if there was a way to do "If fruit is any of apple or orange AND dessert is cookie THEN show the following fields: grocery" , so that two different fields (columns) could be used…