Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Shared document with only certain colunn
Hi, I have a question, can we share the document with users that they only can see & edit certain columns info? Cheers Quece
Return a date value that is the 1st day of the month, depending on what month we are in today.
I need to create a formula that if a checkbox column is blank, then a date is entered into a Start Date column which is the first of the month of todays month date. The checkbox column is checking if the row was created in 'This month'. So if a row was created on 3rd April 2016 for example 3/4/2016, the checkbox would be…
Countif with wildcard
Need some ideas how to count number of cells in a range with any text in them. The formula below returns 0 (when all cells in the range contain text) =COUNTIF(Column Name]10:[Column Name]19, "*") Any ideas for text wildcard? Thanks
Incorporate two data sets in one if/sum statement.
I have one column where I want to sum the total amount of days of work, however, I want the sum column to be dynamic based on the %Complete column if the percentage is <100%. I want the Sum column to show a total value anytime the % Complete is less than 100%.
Can the IF() formula use a conditional test from a different sheet?
..or does the test have to be within the same sheet?
Problems writing zip codes starting with Zero "0"
Hello there, I'm unable to put in zipcodes starting with "0" in the Text/Number Column, it autmatically removes the zero's leaving only the whole numbers behind. Is there a way to disable this feature? Regards, Paul
Reporting Services down?
I am unable to open any of my existing report , here is the error message: an unexpected error has occured running your report and the smartsheet.com team has been notified. Am I the only one?
Conditional Formatting on Parent Line
I created conditional formatting that allows me to color code based on % complete of child tasks, however this does not carry into the parent line as I have dependencies enabled. I would like to be able to visually show the progress of a project based on the average of the children status on the parent line.
Feature Request: Multiple column selection in Conditional Formatting
I have a customer that wants 7 columns to be the same format when a single condition is met. I would like a multi-selection option for the "Select what to format. This may even result in a performance improvement for this use case. Craig
Create dependency reminder by date
I'm looking to create a content tracker that includes a reminder to review once a document has reached a certain age. For example, Content piece one contains a column for "publish date", once 6 months have passed since that date, I'd like a status column with options of "current, needs review, outdated" to reflect status…
