-
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…
-
Creating a Cash Flow Model
Dear Developer I would like to know if any one be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers etc. I…
-
Creating a Cash Flow Model
Dear Developer I would like to know if someone would be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers…