-
Combining cells from one sheet into a single cell on another sheet
I have a master spreadsheet with many columns (sheet1). From that, I want to create a second sheet with fewer columns (sheet2). The first column in sheet1 is 3 cells combined (=[Column1]1 + "-" + [Column2]1 + "-" + [Column3]1). In sheet2 I only need the info from Column2 and Column3. Is there any way to do this from a…
-
Changing % complete using a formula in another cell
I know you cannot use a formula in a "% Complete" field. Is there a way to update "% Complete" from a formula in another column (something like a "helper" column)? I have a "Task Status" column with drop down values of Not Started, In Progress, and Complete. I would like to change the value of "% Complete" when I change…
-
Excluding Multiple Options
I am having a real challenge with a particular function. I'm thinking someone will know this right off the top of your head. =SUMIFS({Digital Marketing Workflow- Total Hours}, {Digital Marketing Workflow- Priority}, <>"Sub-Category", {Digital Marketing Workflow- Project Cat}, "Advertising: Concept") I am trying to exclude…
-
formula help: Incorrect Argument Set
Hello, Please assist a novice. The Excel formula works as intended, but the Smartsheet formula throws an #Incorrect Argument Set error. What am I missing? Thanks, Jeff Excel: =IF(ISBLANK(B5),IF(A5>TODAY()+14,"greater than 14 days", IF(AND(A5<=TODAY()+14,A5>=TODAY()),"within 14 days", IF(A5<TODAY(),"overdue","error"))),"not…
-
Drop Down List with If Function
I am trying to do a calculation with the IF function that will allow for a commission calculation to take place depending on the transaction type. Here in BC, I am a real estate agent and want to have a calculation based on who is representing whom. For example, the agent representing the buyer will receive the below…
-
SUMIF and WEEKNUMBER
I have a connector that pulls in all tickets closed after 1/1/2020, and the points associated with each. I want to sum up the points for all tickets closed each week. My formula is: =SUMIF(Week:Week, 1, [Story Points]:[Story Points]) I did some searching and found you can't sum on formulas, and added the 'Value' column…
-
I'm trying to do a count in a column based on a specific date.
If I wanted to count the number of cells in column B had the date of 1/22/20, how would I go about doing that? I've tried the following with no luck: =COUNTIF([Customer Account Creation Date]2:[Customer Account Creation Date]70, DATE(20, 1, 22))
-
Formula for % of checked boxes
I'm requesting help to create a formula that will calculate the % of the checked boxes that are checked vs unchecked for calendar year with a project status of complete?
-
Average Formulas
Hi all, Need help with trying to get a formula for Averaging Transit Days for certain criterias in Carrier and Origin. Ultimately I'm trying to build a dashboard of transit days for each origin location. Below if formula I am trying, but I'm not getting any output. =AVG(COLLECT([Transit Days]:[Transit Days],…
-
Is it possible to add dynamicaly a line ina summary sheet if a new sheet is created in a folder?
Hi there, i manage several projects. Each project is in a individual sheet. I created a summary sheet to gather information from projects. When i create a new project in a folder, i wonder if it is possible to add this new project inside the summary sheet dynamicaly as a new line? I tried the report, i just have to click…
