-
Setting up a Point of sale Sheet
Good afternoon, I was thinking of setting up a POS/point of sale sheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc.. Then it came to mind that I should check here. I did speak with…
-
Planned and Earned Value into Project
Wondering if anyone has done any formulas for either Planned Value (PV), Earned Value (EV), into their SS projects? I have all the costing,tasks, opex/capex.%Complete,dates.. in my projects and this would be my next step :)
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
-
hh:mm:ss format??
I am logging time spent per job using timesheet software, and the data it exports is in hh:mm:ss format. Is this date useable in Smartsheet? From this, I want to calculate a job cost. In Excel, I would do this by using the following formula: = hh:mm:ss x hourly rate x hours in a day (24) This would give me a £ value for…
-
Scheduled email based on a condition - Request
First off, having scheduled email across the entire platform would be a godsend on its own. Such as from a report. This way i can have only the information i want them to see is sent. Secondly, sending an email based on a condition. Basic example, if a box is check, send the email at such dy and time. Is there a better or…
-
Template for Capital Raise
I'm new to the community and Smartsheet . Does anyone have a template for a capital raise or know of one that I may use? We're a start-up raising our first round and I need to keep track of to whom our investor docs have been given, who on my team introduced us and next steps. Thanks for your help!
-
ASK: Adjust the automatic settings when you add a new row
hi everybody .. I have a simple sheet to calculate the revenues and expenses and gross remaining in the treasury (balance) .. But This sheet has a specified number of rows, and each time if i add a new row must I add the calculation for the row to get the total (balance). How can I add a new row and takes the same…
-
how to sum the column amounts, if the status of each raw is Green and that is before end of may
trying to establish a quick summary report for Senior Management. want to sum the amounts in the contracts column, if the status of raw items are green and the date is happening before end of may. highly appreciate your guidance.
-
Construction template
Has anyone created a template for construction comparing %completed, %programed and %paid vs the date? to be able to graph it something like this
-
Help with Status and Date Columns
Hello, I am having trouble with a formula. I have 3 date columns, and 1 status column. I would like the status to change with the input of a date in the columns. Here is the reasoning for the question. I have "Ready Date", A "Start Date", and a "Complete Date". When a date is in the "Ready Date" column, I want the status…
