-
INDEX/MATCH not working
Below are two screenshots. The first is a screenshot of my target sheet. The other is a screenshot of my reference sheet. On the reference sheet I have a list along the left. In the column to the right is: =TODAY() On the target sheet is an identical list with the following formula to the right: =IF(TODAY() = INDEX({New…
-
AIA G703 - Form Template
I’ve created a modified version of the AIA G703 form in Smartsheet for use in monthly tracking of my financing of a land development project. Each time a new funding request is made, a new sheet is submitted which includes a colum for “work previously completed” which needs to sum several columns from the previous funding…
-
Invalid data type/unparsable for date countdown
I'm trying to have an automatic countdown but I keep running into an invalid data type or unparsable error. I am trying to show how many days remain until a point in the future (07/17/2018). Here are some of the formulas I've tried without success: =NETWORKDAYS([timer start]1, [Minimum billing date]1) =[Minimum billing…
-
Conditional Web Form Formatting
I am aware that limiting characters in a form (text) field does not exist. Is it possible to apply a conditional formatting rule to a text field in a form that alerts the submitter that they have reached a specific character count (in the field) prior to submitting the form? For example: When character count is greater…
-
Doing by date and not by task
We are a Habitat for Humanity affiliate. We do a group of different tasks on each day we build. Can I have a task for the days such as Day One, Day Two, Day Three and so on and make that the predecessor for the different tasks done on that day. If not how do I do it.
-
Summing children rows without double counting parents
Hello friends- I am creating a spreadsheet to help track project financials for a specific grant that the non-profit which I work for received. Specifically in the Summary Table, I have a sumifs formula which grabs specific line items based on the date and which installment of the grant they are using. I believe that the…
-
Sub-task card lane driven my main card
I am using card view as a materials log and I have a question regarding the 'grouping' of cards. The problem: We have a pallet containing 4 boxes. The pallet is assigned to a lane in the sheet. I have created a sub-task card for each box on the pallet. When I move the pallet card the sub-task cards remain in the lane. The…
-
Auto Status Change/Update
Hi, I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08/24/2018 and it is 08/25/2018 and the status box of completion is not checked yet, is there a way to create…
-
IFERROR and ISERROR do not work properly!
No matter if I use IFERROR or ISERROR formula Smartsheet always returns #BLOCKED Some how the back end ignores the IF/ISERROR formals and is returning #BLOCKED =IF(ISERROR([Project name]1293), " - ", "Green") result is not - but #BLOCKED =IFERROR([Project name]1293, " - ") result is not - but #BLOCKED
-
Need Flag or No Flag based on one or both of two columns being blank or within 7 days
Used this formula to get No Flag and Flag result based on the date/whether the cell was blank. =IF(ISBLANK([Date1]2), 0, IF([Date1]2<= TODAY(7), 1, 0)) Now I need to get a Flag if the date in Date2 column OR Date3 column is within 7 days and No Flag if the Date2 column OR Date3 column are blank. I think I got the blank…