-
Dynamically Updating Row Information
I am looking to dynamically update add or delete a row in a sheet based on a checkbox on another sheet. Specifically, we have a sheet that contains all our outstanding balances, and a sheet that contains all our job info. We are looking to have it add a row to our balances sheet when our checkbox isn't checked, and delete…
-
Loading .jpg logo
I cannot load our jpg logo. It is readable by every other software program I use. The logo is attached to this message.
-
Sumif across Children and Grand Children
Dear Community, I am trying to SUMIF accross all Children and Grand Children but unfortunately retrieving an #UNPARSEABLE value. Here are the formulas I have been trying: SUMIF($[Payment Status]5:$[Payment Status]50), "Received", [2019 Wk 02]5:[2019 Wk 02]50)) => result to #UNPARSEABLE SUMIF(CHILDREN($[Payment Status]27),…
-
Notifications not working?
Hi, I have set up notifications on my Smartsheet for our Ordering Process. The notifications act as Order Confirmations to Customers to give them details of the Order being processed and Despatch details. Over the last couple of days, these notifications have stopped sending out. I have checked the settings of each…
-
Adding together multiple COUNTIFS?
Hey everyone. I'm trying to implement a formula that will allow me to reference two ranges from one sheet and follow the specified criteria that is given to them. My most recent attempt; =COUNTIFS({Unit_Type}, "CP2 - Double", {ACCS Overall}, [T2]26) + COUNTIFS({Unit_Type}, "CP4 - Double", {ACCS Overall}, [T2]26) +…
-
Formula irregularity
Fairly new to Smartsheet, although I know my way around an Excel spreadsheet. I am trying to create a count of how many reports are submitted per hour on each given day. The reports come in via a Web Form, into the Taxi Rank Data sheet. I have created the following Sheet (see attached jpg) with the following formula,…
-
Formula to automatically check a box when a certain cell is populated
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like a certain box to be…
-
Visual Gantt with Milestones Embedded
I'm trying to add a dynamic visual Milestone gantt on a Dashboard which lists %progress. This should be dynamic so that it displays real-time updates from the detail schedule that i'm pulling the Milestones from. Any suggestions on what tools are available.
-
Two different triggers for one check box
Hello, I find this community very helpful in the search function, but I haven't participated much with my own questions. I'm hoping you can help. I have one check box that I would like to be triggered in two different situations "this OR that" kind of question. I have it programmed for one parameter, but I don't know how…
-
OR function to check a box
I am trying to get one box to check under one or another conditions. 1. when a certain cell has any text 2. When another certain box is checked The function I came up with follows, but it doesn't seem to work. There might be one small tweak I need to make, but I am still new to making formulas. Thanks for your help!…
