-
Extract Column Name using a Formula
Hi, I'd like to be able to extract column names using a formula and use them as row headers. Is this possible?
-
Using RAGB plus adding Blank Cell action
I am trying to use the RAGB indicators to look at if a Due date is set and then setting the Indicator to Red if in the past, Yellow if in the next 3 days and Green if in the future beyond 3 days. We are also using the Blue to indicate if the task is complete. This works fine with the following formula, however for blank…
-
combining formula to round a sum
I'd like to know if I can combine the two following formulas in some way so that I only need one column: In the first below, I'm calculating the average number of minutes an editor spends on each page of a document. But, because I don't want to report the number with such precision, I have a second column with a formula to…
-
Date Formula to exclude weekends
Hi Friends, I need a formula that would result in a Date = Today + 1 day, but if Date is on a Saturday or Sunday, Date should be the following Monday. I also need the same for Date = Today + 3 days but the calculated Date should add 3 week days (Mon - Fri) and not be a Saterday or Sunday. Hope this make sense?
-
New Filtering and Filter sets
Hi All, I appreciate the new Filtering functionality to make and share filter sets with users, great idea. I have a refinement to suggest. Can I ask to have a filter condition included to equate the value to a maximum or minimum value of the field? is same as Maximum is same as Minimum This way when a maximum or minimum…
-
Formula trouble with IF or IFS
I have a sheet being used as a project schedule in which I want to auto-indicate the project lifecycle stage in a cell on the sheet's meta-data line. To do so, I envisioned using an IF AND statement or something similar. Below is a mock up of the way it might look in excel. Project Lifecycle Phase = XXXXXX COLUMN B C Row %…
-
Adding a numeric value to a cell with a checked box
I'm having a hard time and maybe it's because it's obviously not even possible? I'm wondering if a checked box can also equal a numeric value without adding additional columns. Possible? (Photo referenced below) If so, GOAL: Ex if checkbox is checked in this cell in Column BIGKY then that cell has a value that equals 50.…
-
Currency converter
Hi, I have project expenses in different currencies (EUR, GBP, CHF, AUD) and need to convert them all in USD. Is there a solution how I could enter fix exchange rates and after entering e.g. EUR 100.- to get it automatically in new cell / row converted in USD 112.-? I have added the example
-
Feature request: Enter formula in report
I know that Smartsheet does not currently support creating formulas from a report. Any formula manually entered in will display as plain text rather than performing a calculation. I am not sure how the would work, but it would be nice to have a way to enter a formula into a report and have it calculate. I envision this as…
-
Counting checkboxes
Hello, I am counting the children of selected check boxes and then seting a ball color with formula bellow: =IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 2, "", IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 1, "Red", IF(COUNTIF(CHILDREN(Comp15:Comp17), 0) = 0, "Green"))) This works fine but, when I have more than three checkboxes…
