-
Formula Help (does not contain)
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today or > =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1)) How can I combine AND if "Part Status" is NOT "shipped"…
-
tracking Project by the hour
I have started a small project shedule for a job that will take around 72 hours to complete total but with multiple subs having to start and finish at certain times to hit that deadline. how do i change the calendar on the Gant to #1) just show me the 3 day assigned to the task #2) break each day down to a 24 hour time…
-
Filters
Hello, I have a Master sheet setup w Task Names being my customer column. From that I have filters setup for each of my processes which is in the Assigned Column. The filters for example will show all the jobs on the finishing calendar. What I would like to do is setup a filter that would show all the processes for one…
-
Formula Help
I have the following formula in a cell =([Actual Case Rate Achieved]57 / [Expected Hourly Case Rate]57 * 1) This data in the cells "Actual Case Rate Achieved" & "Expected Hourly Case Rate" are not always filled in at the same time, so when information is missing I am gettignthe error "#invalidvalue" I would like my formula…
-
External Collaboration & Communication (Outside Company Contacts)
If I send a written proposal through Smartsheet, as an attachment to an Update Request, and the client responds, I know that I will have an email verification, showing me any changes to the worksheet. However, at a future date, if our client wishes to send an approval verification through Smartsheet, they cannot use the…
-
Filters
Is it possible to add a field in the Filter to sort a to z. I would like to sort open items and by what is the nearest due date. Right now it's a 2 step process. Thanks.
-
Keystroke(s) to quickly enter toady's date?
Hello, In Excel it's {ctrl}; Is there a way to do it in a date field on a SmartSheet?
-
OPPM_One Page Project Manager
I am new to Smartsheet I am a big fan of communicating task and project status via a single page. Does anyone have experience of using Smartsheet using the OPPM format?
-
Report on Previous Entries
Hello! I'm curious what would be the best way to report a cells previous vs current value. For example, last month we had a status set to 15%, and this month it's updated to 20%. I'd like to see the 5% change as a percentage, or even an icon on a sight. Can this be done natively through the changelog, or would I have to…
-
Add a row to an existing update request
Is it possible to add a row to an existing update request. I have a sheet that allows users to select an update frequency (i.e weekly, monthly & quarterly) for their initiative via the webform they use to load the initiative. What I would like to achieve is to set up an update request for each owner (weekly, monthly and…