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…
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.
Has anyone created a template for construction comparing %completed, %programed and %paid vs the date? to be able to graph it something like this
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…
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.
Im trying to develop a sheet for a Quote Estimate to Customer with customer details auto added from contact sheet?
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…
Is anyone using Smartsheet for their restaurant clients? My thought is to setup a wordspace run everything from new employee forms to inventory counts.
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…
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…
