Hello,

I want to use the AVGW function to get the weighted average of the column "Cost" against the column "Probability of Cost" but only if the column "Status" is Approved.  The column "Status" can also be Pending. 

The function SUMIFS works great if you don't need to do the weighted average.

I am trying to figure out a formula that when I change the value of the %complete to %100 my status column with drop down list pics a specific word and fills it in the cell. Can this be

Has anyone received this error message before?  What are the options for large data?

Kia ora everyone,

Couldn't find anything relating to this question, but feel it can't be the first time asked :-)

I'd like to have an alert on a date column, so that 30 days prior to that date we are notified.

Is this possible?

Thanks,

Brendon

Hi everyone,

I need help on the following topic. I am trying to create a formula to show (measure)  the running time in days between the column "done" and the column "creation date"?

 (see attached image).

Thanks for your

Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come in indented so I have to manually indent each row as it hits

Hi is there any company here uses smartsheet in philippines specially in metro manila? may i know the company name thank

I'm building out a plan with tasks and dependencies and want the dates to populate based off a vlookup. For example, If "Sprint 12" is selected then the proper start date is set in the Sprint Start Date column...which I am doing now with =VLOOKUP([Sprint Start]4, $[Sprint Start]$123:$[Sprint End

Hi all,

Consider that I have an index sheet that lists all the projects (active or not), with the current task, it's description, timescale, owner of the task, and also the task that will come next.

Parallel to that, I have individual sheets for each project that list all the information above,

Hi to all and thanks for considering my request. We're somewhat new to SS, have looked at all templates without finding a product evaluation feedback form that would allow users to share issues, insight, feature requests and help requests for a 30 day product evaluation period. I'm not expecting to