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
Quarters in fiscal years formula
Hey all, I'm trying to write a formula that will return the quarter and fiscal year (FY) of a given date. Our fiscal year is October - September. So for the first quarter, the FY doesn't match the calendar year (CY). So far I've been able to execute this for one CY, but if I try and add a second CY, I get back a blank…
Nested IF Statements
Brand new to SmartSheet. Looking for best method for nested IF/THEN statements to provide status. Or alternate methods. Example... IF column N has any value, THEN column B shows Status 1, IF column O has any value, THEN column B shows Status 2, etc. My nested IF/THEN statement from Excel didn't import.
Errors in Changes made by
I have automatic reports sent out when an item is past due. Sometimes the person listed at the bottom is not the person who made the change. Any way to prevent this? Glenn
Indenting not working right
See screenshot. When I indent my headers, the expand/minimize button is all the way to the right (circled in red). I would like it to be in the cell with the header label. I cannot figure out why it keeps putting it all the way at the end. Second- When I try to do additional indenting below that point, it doesn't seem to…
Future Date Calculation
Hello, I am trying to find a formula that will calculate out 90 days from a given date AND give the result as the last day of the month. The given date is Completion Date Estimate i.e. 10/31/2017 of a project and I would like a cost cut off date that is 90 days later on the last day of the month i.e. 01/31/2018. One…
Duration in a summary task show "hours" instead of "days"
I have a series of sub-tasks in minutes and hours but then the summary task shows the duration in days. It is frustrating to not be able to change that, is it possible or could that ability be added to change the duration display in summary tasks? Thank you, - Blake Chesley
Non-working days are no longer greyed out - Bug?
Hello, We have recently begun working with Smartsheet and we detect that nonworking days are only greyed out when the setup gantt menu is openned. Is there a bug in our system or a configuration is needed? It occurs with a single new project without changing anything. We have seen a similar discussion but without…
Count Cells by Color
how do I count cells of a specif color in a row? Countif does not seem to do this as it does in Excel.
Round to nearest 0.5
Hello, We are building a time management sheet based upon a simple Smartsheet feeding information from a Form. After we've received the information we want to round the calculated results to the nearest 0.5 (see screen capture) The data we receive are collected and calculated in plain text/number columns. The Round formula…
Images inserted in the cells disappeared
Hi everyone, I just got a weird problem with images in cells. We were using this feature for a while now, and we had an uploaded .jpg images in every row, while we got to approx. 500 rows. Right now all our images disappeared and were replaced only by images' former name (like image.jpg) text in that cell. When I…
