-
Resource management..... what is your idea?
Hi, I turned of resource management, i don't know how you guys see this working the way you implemented this. Sure the idea of one view is logical but my people work different hours, some 4 days 9 hours, some 3 days 8, etc. I tryed to make it work but it is just not possible without allot of extra steps. If you have a way…
-
Charts and Sights
Is there a way to get a Smartsheet Chart in a Sight?
-
Bug?: % Complete report filtering
Is this a Bug? I've set my report to display rows where %complete is "less than 100 or is blank" but the report continues to pull rows that are set to 100. This behaviour seems to be consistent in all my sheets, including this brand new one I created from a template!
-
Auto pre-populate a web form
Good day, I would like to pre-populate a smartsheet form with values in certain columns. I see that you can auto populate a section of the form by manually entering (post-URL): &ColumnName=text. However, I want to avoid having to create each URL by hand, this will take forever. Is there a way to automatically generate the…
-
CountIF formula for two different columns??
I'm looking to find a way to create a count statement if one column contains "a" and the other column contains "b". Example: If "Status" is "Open" and "Issue Type" is "Bug",then count # I looked to the formula example sheet for this but all I see in one that I believe would work has a "expand rows to see example" message…
-
greater than or equals to
i need to activate a check box based on the following condition. if date cell A is less than or equal to Todays date and cell b and greater than or equal to todays date then check box. how do i write this please as i can get the formula to work all but the equals to bit. ta blair
-
Range selection
Hello, I am wondering how to choose a range on Smartsheet that will go on forever? Please advise.
-
Deleting update requests
I have a sheet for meeting action points and use update requests to keep on top of oustanding actions and mark and action complete when it is done. I have been trying to delete update requests on completed action s but have found you can on some and can't on others (the delete drop down is greyed out). There appears to be…
-
Formula: Count amounts together by specific date range
Hi, I've tried to fix it myself but I'm not getting it anymore. I want to count together on a specific date, which differs at a time. = SUMIF (Due Date) 1, [Due Date] 5, YEAR (@cell) = 2014, Cost1: Cost5) is based on year but I would like to select for example on 04/01/2017 to 04/20/2017 . I hope my screenshot makes sense.…
-
Smartsheet Outlook Add In not working
I am trying to attach an email from Outlook to my Smartsheet project. I have Office 365. I can click on Smartsheet within Outlook, and it asks me to log in to smartsheet. Upon doing this, the Smartsheet wheel inside my email just keeps spinning and nothing happens - I have waited up to ten minutes to see if it will connect…
