-
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),…
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"
-
Linking cells that are dependent
This is going to be a tough one to explain, and I'm not sure if it's possible. That said...: Endstate: For a finance-based sheet ("Sheet 1"), I want one of the values from a user's form (Amount USD) to populate in another sheet (Sheet 2"). Problem: There is a debiting manager (losing money) and crediting manager (gaining…
-
Adding Positive Parents
Hello all, I am trying to set a formula up that adds the sum of several Parent lines, but only if they are positive. Adding all parents under one banner i use the Sum(Children) however, I tried to add only positive parents by using a SumIf(Cell1:Cell5, >0, Cell1:Cell5) but in doing so only managed to add all positive…
-
Enhancement Request: Ability to use Rich Text or HTML format options for Comments
I would like to request the ability to use different format options in the comments window. We are currently able to add plain text comments but it would be nice at times to use a different format like Rich Text or HTML.
-
Adding Months to a Date
The Date formula allows addition but I get errors when I cross months by adding days or when I cross years by adding months. (Haven't tested years with adding days but that also crosses a month so I would get an error anyway. I need it to act like Excel and actually add a year for each multiple of 12 months in particular.…
-
Automated approvals
I have set up a workflow with multiple paths I come to a stop when I get to Decline. Here is my issue We set up an invoice approval flow The 1st step is to have an internal review and the 2nd is to the customer for approval. When there is a decline on the 1st step the next step is to request an update to revise the…
-
Approval Automation Question
If an approval request has been declined. The next step is to ask for an updated revision via request an Upate. Once that is complete I am sending another approval request. I would like the same column to be updated but it looks like I have to create a new column... Or Save Status as Value? Where is that I am looking for…
-
Phone support
Hi, is anyone aware if Smartsheet offers phone support in Australia when needed? regards Michelle
-
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!…
