-
Looking to auto populate red flag for overdue invoice
Im having trouble figuring out a formula to create a flag in the overdue column when the due date is in the past and the status is pending or delayed. Flag needs to disapper once status changes to paid Picture for reference
-
Concatenate formula with IFBLANK
We are trying to move some of our more complex templates into Smartsheet but we're having trouble converting the concatenate with blank formulas from excel into smartsheet. For example we have this formula in excel =IF(M2="","New",M2), and all I can seem to get to in Smartsheet is =IF(ISBLANK([If nothing is indicated,…
-
Is there a Formula (Set of Formulas) that can check multiple dropdowns from other data column?
I have a Metrics sheet in which I'm trying to populate a dropdown list (multiple values) with building types from client portfolios. As an example Client A could have 5 buildings: 3 Office, 1 Industrial, and 1 Warehouse; Client B has only 5 buildings as well: but all are Office. The client buildings are in a sheet with all…
-
Multiplication formula
I need help multiplying two columns. One is a formula equaling a percentage, the other is the value of another column that is adding multiple columns together. I keep getting in invalid value error. Colum - Probability - with the percentage looks like this: Column - Total Software TCV - with the value that needs to be…
-
Hiding formula links
Is there a way to hide cross sheet formula links? If you define a reference range on a sheet for vlookups I would rather not see all my columns on the parent sheet filled with little mouseover links. Thanks
-
Is number rank the numbers
Is it possible to insert a formula to say if a column is a number rank the numbers, if not leave blank? I tried =IF(ISNUMBER([Column to Rank]@row, (RANKEQ([Column to Rank]@row, [Column to Rank]:[Column to Rank]), "")) and it didn't work. FYI the [Column to Rank] column contains a formula. Thank you!
-
Send an e-mail when a box is checked?
Hello -- Very new user here. I have a general technology knowledge, however, I'm having a logistical brain fog at the moment. Could I use an IF THEN statement to send an e-mail notification when a Box is checked? paint drawing (don't have any other fancy program on my work laptop haha) for explanation. Thank you!!
-
Index and Match to return match with non-blank cell
We have product lists, sometimes the description for a product is 20+ lines long. I'm trying to get the important items, such as fire rating to float to the top of those 20 rows. In the example below all of the rows highlighted in yellow are for one product. I'd like to get the Fire Rating data to pull into the same row as…
-
Formula Help - Predecessors disabled/Duration calculated formula to exclude holidays
Hello Smartsheet Community I had to disable predecessors in this project plan. I worked with the ProDesk to come up with a way to have a calculated weighted formula. There is also a formula that calculate the # of days between start date and end date. However, I just realized that this formula does not excludes holidays.…
-
Parent Row Status Formula
Hi all, There are tons of parent status row formulas on this site and I have to first say a huge thank you to the contributors because you've helped me resolve my own problems without opening a new question. Here is my current formula based on the great input I've read from the community: =IF(COUNT(CHILDREN()) =…
