-
Augmenting SmartSheet
Hi there SmartSheet Community, We are using an existing system for job management and for accounting, and have introduced SmartSheet for the management of project plans. In order to meet the requirement for consolidated reporting of project financials and capacity, we have carried out a deal of augmentation around…
-
Turning "=year" value into 2 digit number and "=yearday" value into 3 digit number.
Hi there, With "=year()" function, I can get the year in 4 digit numbers and with "=yearday()" formula, I can get the day in 1 to 3 digit numbers. However, I am trying to combine them into 5 digit number ("YY" + "DDD") to automatically generate julian date. Since Smartsheet doesn't have the "=text()" function, I am not so…
-
Hiding Formulas
Hi, I am designing solutions for several clients on Smartsheet. Is there a way to hide the formula so it doesn't display when you "mouse over" it? I don't want the clients to see "my magic" - very easy for them to copy it and do it themselves... Thx Werner
-
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.…
