-
help with average formula
Hi, I am having trouble with getting an average of a column. its a formula based column and since some rows dont meet all the criteria, some rows state INDEX DATA. How do I find the average of the numbers in the column using a formula?
-
Return 1st column value if 2nd and 3rd column is blank
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column. These columns contains dates by the way. Sent (1st) ; Won (2nd) ;…
-
Apply Formula to Entire Column
I'm trying to automatically apply a formula to an entire column that concatenates info from cells in a given row into a document name, once data is entered into those cells. The only way I've been able to accomplish this so far is to just copy/ paste or drag the formula as data is entered in a new row, but I'd like it to…
-
iPad Dashboard Navigation
When I create a dashboard, I am unable to create a link to a specific folder within the same workspace that is accessible with an iPad. I've tried it a few different ways (URL's, smartsheet shortcuts, etc.) but whenever I press on the link, it just navigates me back, out of whatever workspace I'm in, to the home tab of the…
-
Workflow utilizing data uploader and a template
So here at my company, we have a project template. This template contains many setting, functions, workflows and conditional formats that help organize our information. We currently generate an excel template similar to the one in smartsheets then copy paste into our template. My question is regarding the best way to get…
-
Count dates and return a valve from another sheet
I need to reefer to another sheet and count any row that has a "Fill Superintendent" and return a number if it is =< today in column. Then a valve if its => 60 days Thank you for any help
-
Allow a cell to only be certain days of the month
I put together schedules that include public hearing dates that are typically certain days of the month , i.e. 2nd Tuesday, is there a way to assign this to a cell in my schedule? Currently I have to go to that point in my schedule and manually find the date and each time the schedule changes I have to make sure I update…
-
Gantt Print Problem - Can't choose columns to print
Anybody having problems with their "non-licensed" users not being able to select the columns to print in a Gantt view? The "edit" button for selecting columns to print no longer works. I'm wondering if the recent software update has broken this functionality.. We receive an error that says "An error has occurred in the…
-
Formula value
Hi, I have a job file that uses several VLOOKUP formulas to extract customer information, order and delivery date. When the task is finished I would like the information retrieved wirt the formulas to be embed in the task document so the task file can stop looking for the information. I currently use the Paste special but…
-
Project Cashflow
Hi there, I would like to be able to create a month by month cashflow report from a Smartsheet Project (or a number of projects) based on the schedule and Budget Amount entered into each row. ie. Take a standard Project in Smartsheet, which has rows for each task (along with STart and Finish times) and has additional…