-
Calculating a minimum payment figure using a formula or function
Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my finances in order and thought I'd use Smartsheet to plan this. I've done a screen shot…
-
Average Children they are not 0
Hello - We are building a tracker that rolls up averages for a series of values across child rows. We have a top level value, with 12 children for each month, and each month as children rows of workers. So for example Manager Indent(January) Indent(Indent(Worker 1) We are trying to roll up for the manager, by month, as…
-
Index Match help
I am trying to convert from Excel to Smartsheet without adding a ton of columns to make this work. I am not if Index/Match is the way to go OR VLOOKUP, etc. Again, the entries from the operators will vary therefore the low/high specs are used in previous columns that you helped me with. This is the excel version of ONE…
-
=ISBLANK, =IF??
I need help working out a flag formula, please. If [Cell] contains anything (is not blank), turn on the star If [cell] is blank leave star off I have tried these - none work: =ISBLANK([Date Invoice Approved & Who Requested]@row, "Off", "", "On" =ISBLANK([Date Invoice Approved & Who Requested]@row, "0", "", "1") =IF([Date…
-
Calculated date that doesn't fall on weekend but next week day
I have a date field (Date to be Completed) where I calculate so many days before or after a "Course Launch Date". I need to make sure that if that calculation lands on a weekend it automatically advances to Monday. Here's the steps, just can't figure out the formula. Course Launch Date: (PARENT): 5/26/20 Date to be…
-
Add a Metric widget on a dashboard that shows last modified date & time
I am trying to add a metric widget to a dashboard that shows both the date and time from the last modified column in a sheet. It seems I can only bring in date, not time. Is there a way to show both elements? Thanks.
-
Flag Formula
My formula for the below isn't flagging correctly. Can someone take a look at it? Intended action: If [HRSS Sends Request for Personal Info] has a date, AND [Credentialing Initiated HRSS] is blank after 7 days, flag Formula: =IF(AND(ISDATE([HRSS Sends Request for Personal Info]@row), ISBLANK([Credentialing Initiated…
-
Formulas for flags
I need some help with formulas - cell names are in brackets. If [HRSS Sends Request for Personal Info] has a date, AND [Credentialing Initiated HRSS] is blank after 7 days, flag If [Credentialing Initiated HRSS] has a date, AND [App Completed in Portal by Provider/CVS] is blank after 7 days, flag
-
Formula to determine how many times something occurred in a row
Hi everyone, For my business I have multiple trucks, and every morning we record the statuses of the trucks before they start driving. I have multiple columns, each one being the different trucks. In the rows for those trucks I record the statuses for the different trucks. So I have "Available","Breakdown" etc. I'm trying…
-
VLOOKUP with Multi-Select Column
This discussion was created from comments split from: Announcing Formula Support for Contact Columns.