-
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!…
-
IF COLLECT / MATCH COLLECT / INDEX COLLECT / VLOOKUP ?
Dear Community, I am trying to have an automatic filling of the column [Budget Max] while changing the column [Level] based on 2 other columns references: [Level attribution] and [Max Budget Range] with matching ROWS. If [Level]value = [Level attribution]value return [Max Budget Range]value of the same ROW of [Level…
-
Summarizing from multiple sheets (count, drilling down, etc.)
I've been searching the Community section but am having a hard time finding the exact answer I'm looking for, so I hope someone can help. I haven't worked with Reports or Dashboards before, so I'm just not sure exactly how to set up my sheets for this new project. My company is conducting reviews of our office locations a…
