-
sum hours assigned to a contact on a sheet for a particular month
Example: I have a project that lasts three months on a project sheet. I am required by the client to report out how many hours of work have been completed by each person assigned to a task at the end of each month on a dashboard So for example: I need a formula that is going to Find all columns assigned to the contact…
-
VLOOKUP in Contacts Stops Halfway
I've been using the VLOOKUP function to populate contacts that I have saved in a separate sheet as my master contacts table. The names are alphabetical on both my destination and source sheets. When I drag the formula down on my destination sheet, it pulls the contacts but keeps stopping halfway at 'M,' where it says there…
-
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:…