-
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()) =…
-
How can "successors()" just show direct successors?
Hi - I find a "successors" column useful. I can easily make a column with a column-formula of JOIN(SUCCESSORS(X@row),", ") - great. But if the successor is a parent row, I get not only the successor row shown but also all of the children of that row. Like this: I don't want to know that the tasks on lines 3 and 4 are…
-
Hi, I'm trying to reference a cell that contains a dollar amount based on a date range.
This is what I'm trying (unsuccessfully to accomplish) =IF([DATE SUBMITTED]@row >= DATE(2022, 12, 1), [DATE SUBMITTED]@row <= DATE(2022, 12, 28), "PO Amount Including Change Orders" Looking for the amount in "PO Amount Including Change Orders" to show up if the cell "Date Submitted" falls within the date span. Any ideas?…
-
Remove partial text at beginning of cell
Hello! I'm trying to use a formula to eliminate the first 4 characters at the beginning of a cell. Help would be greatly appreciated!
