I have long countifs formulas on a metrics sheet and is pulling all data from an archive sheet. One of the colums on the archive sheet is date. I need to limit the data count on the metric sheet to on…
I know you can up type in a list of values into a drop down list but can a drop down list be dynamically populated with data from another column? Can you use values in one column (column A) as input t…
Hello, I am working to create a widget on a dashboard. In order to do this, I want to get data between a start date and end date (turnover time) per month to show monthly progress. I have tried by fin…
Good morning, When I use excel, I have the ability to combine several cells together using the "HYPERLINK" formula, and am able to get a link generated automatically where it will point to an outside …
I have created a dashboard that I want to display the number of ideas created (and maybe count how many in each status). I am using a widget to link to a value in a sheet. My sheet I am linking to is …
Hi everybody, I'm new to smartsheets and I'm not sure if there's a name for what I'm looking to do. I volunteer for a small afforestation project in my local area. And want to make planning our planti…
Hello, Can I get some guidance on how to properly use Parent/Children formulas for a Summary sheet that is fed by information from a reference sheet? I have several count ifs, and sum ifs all correspo…
Hi everyone, I encounter one issue creating formula and linking between two different sheets. I don't know which formula to use but let me share with you what I have done and if you all have a solutio…
Let's see if I can properly explain my question! I'm using the Meeting Agenda template to create and track agenda items. I'm then using that sheet to add notes to each agenda item during the meeting. …
I have a database sheet which is filled out using a form. It records many different items being checked in and out using a Barcode column and a Location column. The sheet auto fills the date that the …