-
Sumifs, vlookup, or date range
Hey I have some difficulty figuring out how to write a formula for my problem. My scenario is as follows: I have to sheets (see attached): * Payment sheet * Cashflow sheet The payment sheet is used to log payments to sub-contractors. There are a date column and a column for each subcontractor. The last column sums the…
-
Auto Lock columns or rows through formula
I want to know if it's possible to create a conditional formula (or something like that) that as a result Lock the row or the column. When the user's filled the entire row I want to lock it from other changes, automatically.
-
Smartsheet in Commercial Real Estate
My team is working on incorporating smartsheet for our landlord and tenant rep clients, as well as our team. Any suggestions on best templates, etc to use?
-
#INVALID OPERATION (SUMIF/SUMIFS to blame?)
The formula I'm trying to fix was not reporting our information correctly so I built a new formula in a test environment and it appeared to be working as intended only for me to find that when applying it in a live setting, the result was constant #INVALID OPERATION errors. The formula is this: =IF([Est. Annual Rent]@row =…
-
Counting Active projects within 2 dates
I have 2 date columns: Actual Start and Actual Finish in my intake sheet and want to summarize active projects by month over time. I setup trend sheet with months and years and want the formula to count actives for the month if: Actual Start is NOT blank AND Actual Start (Less than or equal to the Month/Year on the row in…
-
Counting cells with formulas
My underlying issue is that I'm trying to count cells that begin with a certain number. The data that is present in my SubCategory column is a picklist. Examples: * 106 COST BILLED IN ERROR * 110 FAILURE TO PURSUE PAYMENT AFTER INVOICE SUBMISSION * 201 CLIENT FAILED TO COMMUNICATE WITH FIRM * 207 PER CLIENT - COST IS NOT…
-
Check if Child Row
We use the formula =IF(COUNT(CHILDREN()) > 0, 1, 0) to check a box if a row is a parent row. This is a helpful tool when using conditional formatting to format rows which are parents, automatically. We'd like to do a similar thing if a row is a child row, but I cannot think of a way to do perform this logic. Has anyone…
-
Help with Formulas
Hello! I’ve been using Smartsheets for a while now, but am new to building them. I am having trouble working with formulas to identify current status of my tasks. I’ve searched the community and have tried out suggestions based on previous responses, but I’m still stuck. I’d be grateful for help sorting out the following:…
-
Prorated Rent Schedule Formula Help
Need a formula to calculate what is due per calendar year when the rent amount changes year to year (midyear) Any help appreciated! 06/01/19-05/31/20 Total Rent Due: $175,000 06/01/20-05/31/21 Total Rent Due: $200,000 Total Rent of 2019: Total Rent of 2020:
-
Using IF formula to set conditions for RYGB ball color
Hi there! I have been trying to set conditions with a formula to change the color of a RYGB ball based on two columns, the percent complete and the due date. I wish to use the RYGB balls and not just change the color of the cell, which is why I'm using formulas instead of the conditional formatting. I keep receiving the…