-
How do I get the % to stay at 100% and not 150%?
How can I get the Completion Rate to only show 100% rather than 150%?
-
Sheet Linking
Is there a way to link one sheet to another sheet creating a drop down menu? Example: I am creating a form, but I want to the staff to be able to select the residents from a drop down menu. I have the sheet created with the residents information but I cant figure out how to link it to my "forms sheet' so that they are a…
-
Set up automated workflow to copy child rows to another sheet?
I have a sheet set up with parent rows for each month. I want to copy the child rows underneath the "July" parent row to another sheet using an automated workflow. What condition do I set if I want the rows under "July" to copy to the other sheet on the first of every month?
-
Keeping Reference Sheet Formula
Hello, In Smartsheet, I have a metrics file that has formulas to consolidate numbers (sumifs) by referencing a raw data file. The first version of the raw data file was imported from an Excel file, and it has data in thousands of rows. Every 2 weeks, the Excel raw data file will be generated by our system and I will get an…
-
Count occurrences of each variable of a multi-dropdown list
Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard metric to show how many rows are at a particular stage: Preliminary - 5; Negotiating - 3; At Lease - 7, etc... What would I…
-
Count Responses for the Same Answer, for Multiple Persons
I created a survey and used the following formula to count repsonses; =COUNTIFS({2020 IS Employee Engagement Survey Range 3}, "Vin Miliano", {2020 IS Employee Engagement Survey Range 1}, "4 - Agree") The formula works fine for Vin, as his number of responses is 2. I also have another user, Tim, and his response is 2. How…
-
How do you Sum a Column for multiple same date entries
I have the following sheet (tracker) that I am trying to total or sum if there are multiple entries for one day. Do you have any suggestions on formulas to use? So for the below, I am hoping to get 1 daily total for 7/14/20. I have tried to create a summary sheet and reference the data from this sheet but I cannot get the…
-
Sheet refresh not working
Hello, I have a strange problem and I am unsure of why it is happening. My colleague and I were working in the same sheet and making changes testing some workflows and forms. Changes made by my colleague caused my Refresh icon to immediately appear but when I made changes or added a new row via a form she saw nothing while…
-
Dropdown values taken form sheet
Hi, I have a 7 sheets where I choose salespersons form restricted dropdown list. Is it possible to have one source of values to dropdown list. So I dont have to add-delete salesperson to every sheet?
-
Web Form Update Multiple Sheets
Hello, I need help figuring out how to have a web form update multiple sheets based upon location information. Basically I have put together a web form that will do a site survey of hotel rooms for renovation. We are surveying several sites at a time and instead of creating 20 different web forms that update 20 different…