-
column colors change from two different column status
I have a colored ball column that states if something is overdue from the due date to make the ball red. What I want is the ball to turn back green if the status changes to Completed. I tried this =IF(ISBLANK(Due3), "Gray", Status3 = "Complete", "Green", (IF(Due3 < TODAY(), "Red", IF(Due3 = TODAY(), "Yellow", IF(Due3 >…
-
Enhancement Request: Allow "when condition is not met" for Date columns
In order to do some common date related conditional formatting (for example, aging or older than 7 days ago https://community.smartsheet.com/discussion/setting-conditional-format-when-date-eg-more-week-ago), we need to create a formula. This could be avoided if we had the same functionality for dates that we have for other…
-
Enhancement Requests: Editable Published Sheets
When I create an editable published sheet, I'd like two improvements 1. Show 'locked' icon for rows. Column locks are shown, but the info column is hidden, so the row lock icon is not. 2. Allow publishing of a sheet without editor ability to add a new row. Since the sheet is updated via a WebForm, I can't lock all of the…
-
Start / finish Dates
I need to show the proposed start/end dates in the program to my client. He also wants to see actual start/finish dates. Is it possible to do this?
-
=DATE(YEAR([Invoiced Date]2), MONTH([Invoiced Date]2 + 30), 20)
Wanting the formula to return 20th of the next month when a invoice date is entered. 01/01/17 returns 20/01/17 or 31/01/17 returns 20/03/17. I need January sales to return 20/02/17 etc Where do i put the ERROR formula so it dosent return #Invaled Date Type ? =DATE(YEAR([Invoiced Date]2), MONTH([Invoiced Date]2 + 30), 20)
-
AND + NOT isblank
Trying to produce a formula which says if X is blank and Y is not blank, then check. =IF(AND([Eval Cost]1 = "", (NOT([Client]1=""), 1,0) Thanks
-
Keyboard shortcut for Wrap Cell
Could you please create a keyboard shortcut for ‘Wrap’ text? 1) select: cell(s), columns(s), row(s) 2) keyboard shortcut >> wraps/unwraps selection Thank you.
-
Setting a conditional format when a date is e.g more than a week ago??
Hello all I am fairly new to Smartsheet and am trying to create an 'orders overview & management spreadsheet' for our family business. I want apply a conditional format to a particular date column so that if the date entered is more than 7 days ago, it will highlight the cell in red & bold. I can't seem to do this with the…
-
Preserving Task Rollup in a report?
I would like to create a report to be sent out on a recurring basis that is essentially a filtered version of a report, (i.e. only showing tasks that have not been completed and filtered for tasks for a two week period in the future. I've been able to set the selection logic up in the report, but it does not bring the…
-
Calendar - How Do I Add Times for start and end of meetings, etc.
I'm new to SS and cannot yet figure out why the calendar doesn't allow me to display start and end times for meetings, etc. Is this possible? If so, where is this done? All I see is date related not time. Thank you!!!