-
As System Admin how do I generate a list of everything "Owned" by a former employee.
I don't want to transfer ownership of everything over to a single user before reviewing what they are the Owner of.....Workspaces, Folders, Sheets, etc... Thanks!
-
countifs formula help!
Hey! So I have 17 sheets that I need to pull data from. Each sheet is a form that an employee uses to fill out a survey. Each employee is required to fill out 4 surveys a month. I need to create a sheet that references those survey sheets and tally up how many surveys that employee completed each month. For instance July,…
-
How do I create a report from various forms?
Ok, so I have about 17 forms created for various employees in different departments. Each employee is required to fill out this form x amount of times a month. I want to make a report to auto populate that shows how many times employee filled out the form, and I want the report to show the employees percentage of completed…
-
Why can't I view the Gantt chart that has been shared with me multiple times?
A Gantt chart (and also an additional Smartsheet) has been shared with me multiple times, and they even changed my access to Administrator in order to view it. And yet it still won't show up when I log in. I can view a different smartsheet that was shared with me. How do I fix this, or get in touch with someone in customer…
-
I want to visualize the operating status of machines
want to view the operating status of machines in a line with Power BI. There are measurement points (A to H points) within the line on the circumference, and the transit time can be acquired. I want to visualize if the line is stalled, using the time acquired at the measurement point. In the image of the graph, the…
-
Ideas for the non-existent idea bank
create an idea bank create the ability to have a submission into the grid as a calendar item set as a recurring item add the contact field to a choice instead of email (it used to be this but SS developers changed it).
-
Approval Process/Updated Row
I am working on an approval process. It starts with the use of a form to take in the data, and then the process is kicked off. I have two separate workflows, one for the new row being added; and the next if the size of the class or start date change. The approvers are the same. New Record Approval: Update Approval I'm…
-
Conditional Formatting query
I have 3 columns - Monthly Budget, Budget YTD and Total Spent YTD. I want any cells in the 'Total Spent YTD' column that are greater than the adjacent cells in the 'Budget YTD' column to highlight in a different colour. I don't seem to be able to do this with conditional formatting....or can I?
-
How to avoid columns to send end users
HI, when I trigger alert or reminders mail to end user, all columns are to be add in mail body. so how to avoid columns when when send mail to end users.. I don't need to send any columns details to the end users. send only date based mail and some message on mail body only.
-
link a cell in "Edit" mode
Hello, A have a source sheet from which I am linking cells to the destination sheet. The later sheet is currently in "View" mode only. Does any one have an idea on how I can link cells in different sheets and be able to edit them in both source and destination sheet? Or, if anyone has other suggestions for a similar…