-
Change Flag Color if Due Date is Greater than today
Hello everyone Very new in smarsheet and I have this problem I have basically a due date column and would want another column (flag field or RYG) to turn red once the due date is > today's date. I have been getting #UNPARSEABLE errors everytime =IF(AND([End Date]2 <= TODAY(), [End Date]2 >= TODAY(), RED) Please help.
-
Setting Up Approval Flow from WebForm
Good afternoon, I created a webform that useres could input data to even though they may not have a smartsheet account. Is there a way for any user to submit the form, and then have it come to me directly for approval before populating the sheet?
-
Workspace to share Reports
Hi, I created a workspace, I drag the reports to the workspace and then share the reports by adding people contacts. The people can find the reports in the workspace, but when they open the reports, they are blank. Why? What shall I do? TC
-
MsProject import to template
I need to import a Project from MsProject, but I will like to import it to an existing template. But every time I try to import it from the template it will open a new sheet with the Ms Project info . Is there any way to import the MsProject directly to an existing template ?
-
Row order
when you log in to smartsheet from cell phone, the oldest info in at the top. you have to scroll through all these rows to get to the most current entries. Is there a way to set these sheets up, kind of like an e-mail in box, where the newest info is at the top?
-
Inventory checklist
I have to create an inventory checklit based on an Excel document I will have 2 main sheets: Inventory & Picks Inventory will have a list of all the SKU/units that we have per product. Picks will need to offer me the option to select one item from the Inventory sheet and once I pick it, it has to tell me if we have enough…
-
Outlook Integration - Updating Comments sent out as emails
I currently use the Smartsheet Add-In for Outlook for forward relevant emails to existing (or creating new) tasks and this works well in tracking needed information. I currently use Smartsheet individually and not as part of a team or group. I am wondering if there is a way I can add a comment to a Smartsheet task/row…
-
Please help me with this sheet
I currently have data which is in sheet 1 of my sample sheet attached. I am expecting an output in the format I have made in Sheet 2. The formulae that I have tried till now for the same is in sheet 3. Here is the link to the sheet :…
-
Transferring sheets to other owner
We have an enterprise account. When someone leaves, I move their sheets to another person. I need to have the functionality to look someone up vs. having to scrolls through literally hundreds of names. Ideally, in addition to being able to look someone up, I'd also have the ability to transfer the sheets to more than one…
-
SysAdmin
Good Afternoon, We use Smartsheets rather extensively. Our SysAdmin has since left our company and I need to assign a new SysAdmin to our account. How do I go about doing this? Thanks
