-
#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 =…
-
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:
-
Drop down menu in one box only
I have a housekeeping template for 150 different properties, and I want a drop down list on the top left corner in order to identify the property when it is checked. Can that be done for just one cell?
-
Routine reminder
Hello, I am trying to set up a routine reminder to notify staff to submit a report. I would additionally like to have it notify other staff to follow up to collect reports once the due date passes. I set these up as two different workflows but if I can combine let me know. I am also trying to find a way to not have to…
-
Surveying Project - How to setup the structure of Smartsheets
I need to send out Architectural Survey team out to the field to survey the existing conditions of a restaurant. Information gathered is Electrical Information (Panel Size, # of Breakers), Equipment (Make Model and serial#), Condition of Walls,etc. I'd like to send them with a Ipad with a Smartsheet form, but I'm…
-
Sorting and conserving formula
When I sort rows, the formulas are not maintained: = SUMIF($[column_A]$7:$[column_A]237, "Received", [Column_B]$7:[Column_B]237)) gets transformed into this: = SUMIF($[column_A]$57:$[column_A]237, "Received", [Column_B]$57:[Column_B]237)) the $ has no effect. and I cannot use the [column_A]:[column_A] syntax as it will…
-
Best Formula
I have a construction schedule with start and finish dates. I want the check boxes for the at risk column to automatically check off if the project is late starting or late finishing. Can anyone help me craft the appropriate formula for this? Is there a good formula for this? I was thinking it would be an if then formula…
-
Commercial real estate best practices
Hi Community, We are looking to connect with some fellow commercial real estate management (or similar) companies to share use cases and best practices. Anyone out there? Thanks in advance!
-
Number formatting in Sheet Summary
Hello all, I'm using sheet summary to get rid of the top row on our master project list. Formerly, we used "=SUM(CHILDREN())" to add up all projects & sub tasks.The top row was only there to add everything up. We moved this function over to the Sheet Summary & it's working fine. My issue is the number formatting. The…
-
Formula Help
I'm having trouble putting together a correct formula or workflow to do certain tasks. I have a rent tracker spreadsheet and want a formula to basically say "When it's 30 days prior to the Rent Increase Date then automatically turn the Status Column drop down to red. Once the Status Column drop down is changed to green…
