Hello! I am referencing a single row of pertinent information into "Sheet #A, Master" from multiple other sheets "Content Sheet #b"; "Content Sheet #c"; "Content Sheet #d"; and so on. That works, but …
I have set up a summary grid pulling information from another Support calls grid so I can keep track of logged calls completed by members of my team. I am currently using the formula below to pull tha…
I have a large project sheet that contains (1) cross-sheet links and (2) formulas to calculate due dates based on other tasks. I needed to change the sheet to only populate weekdays (no weekends) so I…
Hello all, I'm new to smartsheets and working on setting up a barcode based inventory management system for the warehouse I run. I feel like I have the transfer sheet up and running just need to get a…
Hi, I'm looking to create a formula and cell reference system that can be used to generate a value that can be referenced in another cell or ideally a form. Here's the workflow breakdown. The field fi…
I found something close to what I am looking for here: NEED HELP: Health Formula based on start date, end date, and %100 complete needed. — Smartsheet Community This formula doe s a great job of flagg…
Hello Experts! I was wondering if a formula like this is possible: =IF([Confirmation #]@row = "any value", "Confirmed") When a confirmation number is added to a cell, that means the item is confirmed.…
Hi! Following up on this feature request, we would also like to request the ability to edit cells from a Dashboard and well as linking to them. Our use case is simple: our team uses dashboards for ind…
I have a main sheet containing a list of projects with the first column containing the ID of the project which is configured as an auto-number column. I am working on setting up another sheet to track…
Hi Guys, I have to count the status. Let's assume I have 5 different statuses (0,1,2,3,4) in another sheet. I have prepared a separate metric sheet to count the status specifically for a date range bu…
