エンタープライズ向けに構築

Sum Network days but if field is blank results show invalid data type

Sum Network days but if field is blank results show invalid data type ... L_123 Community Champion ... =iferror(NETWORKDAYS([Quote Request Recieved]198, [Quote Sent Date]198),0) ... 0 · Share on Fa...

Weeks to go Formula

One way to do this is to have two columns. ... One that calculates the days left and one that shows how many weeks that is. ... You could use TODAY or NETDAYS (see example below). ... Would that wo...

sumif with children and checkboxes

The ultimate goal is that I can prepare a quote sheet for a client with all their options then we can eliminate options to help the budget and our grand total will show the revised numbers, with th...

Adding Nested IF Statement to Formula

Hello MelG, ... Thanks for the question. ... Since this statement should be checked first, it needs to be put at the beginning of the formula. ... There isn't a function that would say a cell "is a...

Conditional sum formula

Hi Ian, ... Here is the formula so that you can easily copy it. ... =SUMIF(Type2:Type18; "Product"; (Value2:Value18)) ... Please also see attached link/screenshot. ... I hope this helps you! ... Ha...

Help with If ISBLANK or statement

01/25/18 ... =IF(OR(ISBLANK([column name]24), ISDate([Column24])), "Late", "") ... Try this... you need to replace your column name you're checking for the date in and set it up for the right row n...

Forms

Using a report to order your inputs might be your best bet. ... Entries from forms can only appear at the top or bottom of your sheet. ... You could apply some kind of filter, but Smartsheet filter...

Formula to auto fill date based on last non blank

01/25/18 ... =DATE(YEAR(INDEX(A2:F2, 1, MATCH("", A2:F2) - 1)), MONTH(INDEX(A2:F2, 1, MATCH("", A2:F2) - 1)), DAY(INDEX(A2:F2, 1, MATCH("", A2:F2) - 1))) ... Was working on this and realized I have...

Formula for SUM by the category

Have you tried the sumifs function? you would need 1 for each category. ... I also used the SUMIF or SUMIFS function for this issue. ... Be aware that the syntax for these two formulas are different.

linking two columns togther

01/23/18 ... Hi Omar, ... There currently isn't a way to link columns together such that you can type their name in one column and have the number appear OR type the number to have their name appear.

Locking rows already saved.

01/11/18 ... Hi Al, ... You'll need to lock the rows manually after the collaborator saves. ... One alternative though is to set up Update Requests for your collaborators, then share them to the sh...

Formula to change RYGG balls when Project Stage changes

01/19/18 ... Any help in this matter will be greatly appreciated. ... Thanking you in advance. ... 0 ... Share on FacebookShare on Twitter ... americansurveymanagement35236 ✭ ... 01/20/18 ... I wil...

Type selected - allows certain columns to be updated

Type selected - allows certain columns to be updated ... 01/19/18 ... Hi Michele, ... With a thought thru set up of Conditional formatting you could accomplish this. ... Here's and example. ... I h...

automatic notifications when dates are passed

01/19/18 ... Hi Jim, ... You'll want to create a Reminder that is based off of a date column and contact column. ... More information on this is available in our Help Center: https://help.smartshee...

SUMIFS with 2 criteria

SUMIFS with 2 criteria ... rjudenberg ✭ ... =SUMIFS([JAN'18 fcast]19:[JAN'18 fcast]160, PRODUCT19:PRODUCT160, "Core: MMS", POSITION19:POSITION160, "CURRENT - CORE") ... 0 · Share on FacebookShare o...

Formula Help - 2 columns and % Calculation

Hello, ... Thanks for the question. ... If I understand what you're looking to do correctly, this can be accomplished using a nested IF formula including the AND and OR functions. ... More on all o...

Nesting a SUMIF function

Nesting a SUMIF function ... rjudenberg ✭ ... =SUMIFS([Q1]1:[Q1]13, CatA1:CatA13, 1, Data1:Data13, FIND("Blue", @cell) > 0) ... 0 · Share on FacebookShare on Twitter ... jagrant35081 ✭ ... This is ...