-
Printing cell history value
I have A1 and B1 which are two different dates (for illustration: A1 is today's date, and the other in the following day). I have data value in Cell C that is changed daily by another cell linking formula from other sheet. Then I have cell A2 and B2 -- the formula in these cells is: =IF(today()=ColumnA1,CellC) and…
-
Track Task Delays
I want to track how long an open task is delayed on a project
-
Login and Display Issues with community
I have been experiencing several issues with the community over the past few days... from all of the profile badges appearing as links, to being prompted to sign in when I already am. Not sure what is causing all the havoc, but I thought I'd make ya'll aware.
-
Looking for form creator - most secure and customizable
I've played with Google forms but don't like it's lack of customization and am not sure about the security. Are there other programs that are more secure that integrate with Smartsheet?
-
Want to track resource allocation
Has anyone had any luck with this? Want to do something similar to the features in Microsoft Project. I have a lot of design projects going on and want to be able to allocate resources (my designers) to projects and be alerted to when a resource is exhausted. Has anyone been able to figure this out? I would really…
-
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
-
number of days between one state and another (not including weekends)
I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this? date of creation| Name | Status | DAYS WITH THAT STATUS 03/03/2018 | cristian | busy | 1 02/27/2018 |…
-
Reporting and dashboard help
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…
-
Troubles when Posting
I keep on getting this message when I try to post a question about some formulas: "Your submission has triggered the spam filter and will not be accepted. If you feel this is in error, please report that you are blocked." Yet this post seems to work fine. Any ideas on what the problem could be?
-
Adding task line in one sheet and displaying in/moving to another
I have individual sheets created for 4 people (one being mine) where we have lines for all our tasks. I use a Report to consolidate all 4 sheets. However, when I have a new task I want to assign, I prefer not to have to access each of their sheets to add a line. I'd like to add the task line on my sheet and assign the Task…
