-
Sumif Circular reference
Hello, I know this is possible within Microsoft Excel, but do not know if it is possible within smartsheet. Trying to do a sumif formula across multiple rows and only change "[Assigned To]1" from to "[Assigned To]2", and for row 3 it would be "[Assigned To]3", etc. using this formula =SUMIF([Assigned To]:[Assigned To],…
-
Stop counting months when a completion date has been met
Hello, I need to have a column that calculates time in a program from a start date freeze when the employee's status changes, it needs to keep counting as long as the employee is still "Active" in the program. I'm working with "Status Code,", "Enrollment Date," and "Date Licensed/Dropped" columns. I have this column set up…
-
Trying to Sum Checkboxes in a primary section of my sheet (not using CHILDREN)...
I'm working on a sheet that will provide me with a team breakdown and weekly breakdown based on checkboxed columns (to make it easier for the end users of the sheet). However, I can't get my formulas to work. (I'm certain that it's due to me being a Smartsheet novice.) I'm attaching a screen capture. Basically, I'm pulling…
-
Formulas Auto-Populating in a Newly Added Row
Everytime I add a new row in my sheet, I have to go in and make the formula go onto that new row. Is there a way to have the formula auto-populate whenever I add a new row into the sheet?
-
Need Help With "VLOOKUP"
I would like some help trying to figure out a "VLOOKUP" formula. I am trying to get the circled number on the attached file to go onto another sheet. I have tried all different ways and I cannot seem to get it to work. Please help.
-
Write Function that has 2 check boxes in it?
Hi everyone, I have had smartsheet for awhile and finally taking the time to learn/use it and am stuck. I have a custom apparel business and have made a sheet to keep track of all my orders and what the cost will be. I have columns for Quantity, Balance, No Fulfillment (check box), and Paid (check box). I have a working…
-
Attempting a formula with multiple criteria
Hi, can anyone help with the formula for the following required outcomes? * $0 if the management agreement has not started [Mgnt Start Date], * Equal to the chargeable amount [chargeable amt] if the Management agreement has started ie [Mgnt Start Date] in the prior month * Equal to the previous month [Jan 17] if the…
-
Date Calculation
=IFERROR(NETWORKDAYS([NAI Project Start Date]7, [NAI Project End Date]7), 0) Cannot get this to calculate The first field has =Another_Cell but the property is set to date. Is this the problem? Im testing the date in the C1 field for being a date with NOPE being the return if its not a date
-
Setting up Days Outstanding
Hi all! I need to fix a column in Smartsheet. The column that says "# of days outstanding" does not always automatically fill for us. How do I fix this, do I have to put a formula in each cell? Also, smartsheet newbie here, I've been working in it for about a week, so I might need extra help. Thanks in advance! Laura
-
Formulas // How to set up one sheet writing to another
I created a project request form for one of my team members -- others on the team enter a request by filling out the form, and so the sheet becomes his workload queue. Another team member has a schedule on a separate sheet with some items assigned to the same resource. She asked if there is a way that if she selects his…