How to display # of request entered by week in Dashboard
Good morning, We have a form used by our team members to enter any issues they are encountering. I have created another Calculation sheet to create my dashboard based from the sheet collecting the data/form. I would like to display in my dashboard how many issues are entered every week and show it in a chart by week. What…
How do I create a report that is a pivot of duplicate items, with a status?
Hello! I have a tracker that consists of multiple contacts per client resulting in duplicate names for a single client, however, a single "status" column that covers the client. I am trying to pivot the client and status however, am struggling to figure this out. I would like to create a report by status that I can then…
Is there a way to auto generate a new row in the same sheet if a criteria is met in a specific cell?
Hi I'm trying to see if there is a way to auto-generate a row in the same sheet based on criteria met in the previous row? To add another layer to the question, is it possible to have the auto-generated row be a copy of a pre-set sample row in the sheet? I'm still new to smartsheet and there may be an even easier way to do…
Need help with a IF
Trying to create a formula where it would originate a % calculation based on a Yes or No from another column. New to this so not sure on how to proceed. This is what I have so far =IF([30C Low income or rural]@row = "Y" , (CAPEX@row * 0.30")]
Creating a test or assessment as a form
I am trying to create a test / exam / assessment in SS and create a formula to auto grade automatically. I created a column for the answer and a column to indicate if each column question is correct. The problem is when the user completes the test via the form, their response row falls below the answers, requiring me to…
How can I use a function to pull dates from Sheet A to Sheet B?
I have a master sheet of dates for multiple programs and projects. The layout of the sheet is: Program | Project | Start Date | End Date Each program is divided into hierarchies as such: Program A --Program A-1 ----Program A-1 | Project A | Start Date | End Date ----Program A-1 | Project B | Start Date | End Date…
Hi. I'm new to Smartsheet. Wondering if there was a template/formula that could assist with this problem? Say I have 10 building sites/projects and they are all staggered one week apart for commencement/completion over a 3 month period. I have a pipeline of projects that I can't start/bring online, until the next project…
How do I stop counting overdue days when the completion date is met using my formula below?
I have column headers (that reference my formula, conditional formatting, and workflows) for: assigned start date, assigned due date, projected duration, days remaining, overdue, start date, completed date, actual duration, and done. My formula to count days "overdue" is below: =IF(Done@row <> "Complete", IF(TODAY() -…
Trying to subtract a value on one sheet from another value on another sheet
Hi, I'm not great at formulas and I'm struggling with something that I feel should be rather simple. I want to compare some month on month data, the current months data is held in one sheet and the last months is held in another. So I used the formula below for the first cell (data range 1 being the specific cell in row 1…
Count if Sheet Summary Formula Help
Hello! I have a sheet summary for in-progress accounts that uses the Status as the CountIf variable. The problem is that the Status formula includes accounts that the Live Date is equal to or less than today. I need to omit the ones with Live Date equal to today for the sheet summary formula and am really stuck on how to…