With so many collaborators working at any given time on the same sheet (you can see when someone enters or leaves a sheet), has any thought been given - is it even possible - to having an IM-type feature whereby you could message others in the sheet at the same time? We already have IM software internally which we use…
Equal = sign is not correctly calculating in formula, incorrectly determining <>
I have create a column to evaluate whether enough resources have been allocated to a task. It evaluates whether the percentage in the % Allocated column is equal to, greater than, or less than a second %Allocated column, which uses a formula to determine desired allocated based on workhours and task duration. [%Allocated]…
Is there a way to add the date in sight without having to create a sheet?
Conditional formatting if task is behind schedule
Hi guys, I'm new to Smartsheet so forgive me to ask the question. How do I setup conditional formatting to a task that is behind schedule? I created 2 lines of conditional formatting already: 1 ) task is 100% complete -> green row 2) end date is in the past and % complete is not 100% -> red row I'd like to add a third…
Setting Conditional Formatting/Formulae(?) for Red Yellow Green balls based on % Completed
Hello, I am trying to have the Red, Yellow, and Green status balls automatically change/update based on the percent completion of each row task. When I click on the conditional formatting button in navigation pane and make new rule of, "If % Complete is between range of 1% and 99%, then change the status column to Yellow"…
Enhancement feature - Merge Cells functionality
Wanted to start a thread for an enhancement feature to try and push this up in the road map prioritisations. For such a simple and standard feature in tools like Excel and Google Docs it has become such a barrier during the process of trying to migrate exsisting documents form the above tools to Smartsheets and now is…
Has anyone created a smartsheet to manage contracts?, specifically to perform the below activities: * track total amount vs. payments * track payments against deliverable complete * track contract term * track contract amendments : to extend the period, increase the budget, adjust terms of reference, etc. * Track invoices…
Formula Bar Blocking Boxes
I'm sure this is an easy one, but when I'm adding a bunch of math in a specific field, it eventually blocks the entire row. I then can't choose boxes within the row that will be nested in the equation. Any way to hide the formula or make it so I can still see/click the boxes behind it? Thanks!
OPen access to access data directly to google docs (spreadsheet) without exporting first
I have feature request on access of data to googlesheets...I want to access smartsheets directly from my own google sheets so that i can build my own fully custom dashboard using google sheets but from that i would need to be able poll the project data directly from smartsheets. I would like that.
Bug: Comparing max(system date) to system date returns incorrect result
I'm trying to retrieve the latest created date and compare it to the date-time. I was expecting to get a date, not a date-time, and that would be OK. =MAX(Created:Created) returns 11/29/16, which is what I expected. However, comparing the [Created] column to this value returns some rows that were created on 11/28: I've…