-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Quote Sheet
Im trying to develop a sheet for a Quote Estimate to Customer with customer details auto added from contact sheet?
-
Alert based on Harvy ball or "last changed date" system column?
I have a harvy ball that shows the progress to completion on a task. Is there a way to send a conditional alert to someone on the task line when the harvy ball gets to a 1/4 or 1/2 full? or even when it changes value (other than any change) Also is there a way to get a tickle when a sheet is not complete and has not been…
-
Hospitality Industry (Restaurants)
Is anyone using Smartsheet for their restaurant clients? My thought is to setup a wordspace run everything from new employee forms to inventory counts.
-
How to find the percentage complete for a project
Hi guys, I want to know the percentage complete for my project. I have 10 tasks below my parent. If 3 of the tasks are checked, I want the parent to say 30% completed. I am using the formula below to find out how many of the boxes are checked. I could replace the 1 with a 0 to find out the number unchecked. I could do a…
-
Currency Prefix within a cell
Hi guys and Girls, A quick one I hope. Can I add a 'prefix' to a cell that shows currency? We use SS with AUD and NZD, thing is they are both a $ symbol. Is there any way to make them look more like their own and show $AUD5000 and similarly $NZD5000? We have 2 seperate sheets so if there is a workaround that I can apply to…
-
Multiple projects on one sheet
We have several large projects that require their own sheets. However, we also have many small projects that do not justify creating separate sheets. They are quick one or two day jobs, but they affect scheduling and P&L need to be factored into that. Does anyone out there use one sheet for multiple small projects? And if…
-
Add Years to a Date
If Term_Effective_Date = 12/07/15 and Terms_In_Year = 3 Years. What is the formula to calcuate the New Date? I need to add 3 years to 12/07/15. =DATE(YEAR(Term_Effecitve_Date2) + [Terms_In _Year]2, MONTH(Term_Effecitve_Date2), DAY(Term_Effecitve_Date2)) I am getting #NUMBER EXPECTED as an error. Thank you for helping!
-
how to automatically generate task lists
Hi, I'm super new to Smartsheet but have seen a handful of videos and am suggesting it as a solution for a bookkeeping client of mine for task and project management. We have created payroll and non-payroll client engagement templates (found on YouTube by schoolofbookkeeping) in her account to be used for each client and…
-
Creating a customer Work Order form.
Good day! We are looking to change our current system of work orders (creating it manually on a hard copy) to doing it via Smartsheet. There doesn't appear to be a template already in existence. Has anyone ever created one? One of our primary concerns is how do we get a customer to authorize the work? Thanks Rob
