-
To set RYG using a formula that considers Todays date and Completion %
I would like to set the risk RYG status column colour based on set conditions. IF % complete = 0 And 'start' is todays date to show Risk IF % complete = between 90 & 100 to show Green somethign like this but it doesn't work =IF(AND([% Complete]row# = "0", [Start]165="TODAY", "Red")) Any ideas?
-
Solution Guides
I just watched the webinar on the multi-sheet Portfolio Management solution. How do I a) find the Solution Guide so I can learn more; and b) lauch an instance of the Solution. As you can tell, I am a completely newbie to Smartsheet. Thanks in advance, charlie
-
Starting Number New Each Month
I use smartsheet as a project management operation for my office. I'm using the auto-number field to create a request number associated with the request, {YYYY}{MM}-0000. I would like the 0000 number to start from 1 each new month. Is there a way to do it other than manually entering in 1 at the end of each month?
-
Number of rows
At the moment Smartsheet supports 5000 rows of information, my excel stands at over 9000. Is there a time frame on when the limit of rows will be extended? Also, my need for rows will only increase so what is likely to be the increase? Without this extension in rows I am not able to use Smartsheet, great shame as it would…
-
Exporting data into a form document
Good afternoon, I've been tasked with exporting data from Smartsheet into a document. The form field ability in Google Docs gives a good format with the fields, but we're needing a way to have several rows of data displayed on one page instead of one page for each row of data. Is there another way to integrate the data in…
-
Smartsheet Forum Navigation-Back to View
As I started using this forum I was frustrated when opening a discussion and wasn't able to go back to my place in a long list on possibly multiple pages. Since there is no back button if you hit the delete/backspace key you will be returned to your previous view.
-
Sheet showing blank
Hi All, I wonder if someone can assist me. I created a sheet by importing an Excel workbook. When I open the sheet via SS, it shows blank. But when I click on the link as in the email I send for the Invitation to VIew to users it opens up the sheet and all the data is there. I am concerned I know to click on the link but…
-
I want to utilise an IF THEN function in Smart sheet
My example is to select a cost rate based on the employee title. If [cell1]="welder" then [cell2]=80, if [cell1]="crane operator"then [cell2]=100, etc, etc.
-
Maintaining a list of small department's resources
My compny is small (about 15-20 resources with limited turnover). To allow all users to work` w1ith the same list of resources as I undestand it, because contact lists are not shared, each user (or maybe just PM) would need to create (or import) a list of names/emails that would then be available to assign to tasks using…
-
Reminders to be sent out after 6 AM
Is there a way Smartsheet can send out reminders after 6 AM and not between midnight and 5 AM?
