I am trying to decide between one sheet vs multiple sheets. I currently have one sheet but it has over 50-60 columns and there are sets of data that will be used by different areas. I know I can filter what is needed (to a point) with reports but it still doesn't give me the end result I need. Here is the breakdown in a…
Hello SmartSheet community! We've been using Smartsheet for a while now throughout our company and so far have several sheets. Some have important deadlines/dates while some just have to-do lists with several tasks that are flagged as important. I'm having difficulty figuring out how to compile all of the upcoming dates,…
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not looking for a time management system, just a tool to enter a student’s hours into a spreadsheet or software to help me manage…
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…
I want to track how long an open task is delayed on a project
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.
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?
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…
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…