-
Check Box if Name in another sheet matches name in current sheet.
I have a Purchasing Log that lists Vendor Name among other columns. I'd like to put together a formula where if the Vendor Name matches Vendor Name in another sheet and if so, return a checked box and if not return an unchecked box. I have messed around with MATCH, IF and INDEX functions and cant get anything to work. What…
-
Need Formula for RowID that will update when rows are deleted or added.
I need a column formula that will match the actual row ID even if you delete a row. I tried using autonumbering, but it does not update if you delete a row, or add a new row in the middle of your old rows. Ex. of AutoNumber row issue 1 (Row 2 deleted below, 3 should change to 2) 3 5 (New Row added, should change this row…
-
Filter tables based on dropdown menu selection
Hi all. I've been tasked with mapping some data key connections between a large number of tables. I am looking for a way to display only the tables that match criteria from a single-select dropdown menu. Some pictures are below to illustrate what I'm looking for. Here's what the raw tables look like. They are laid out like…
-
Creating row formula to be repeated on the same sheet
Good day, can anyone guide me in creating row formulla?. I have a set of data, the normal lies within certain range. When it is above the range, I want it to reflect 'red' bubble, when within the range 'green' bubble and when below, 'yellow' bubble (attached). The issue is that I want this row formula to be repeated on the…
-
Problem with returning a value when a cell is blank
Hello - The first half of the formula below seems to work fine. However i need to return a value if ([Opportunity End Date]@row) is not blank. I'm either receiving #unparsable or #incorrect argument. If you could help, would be greatly appreciated. =IF(ISBLANK([Opportunity End Date]@row), TODAY() - ([Opportunity Creation…
-
Need Help with Invalid Operation
I'm getting Invalid Operation with this formula since the division equation is dividing by zero. How do I fix this so that it shows like "0 of 0 (0%)". If this isn't possible then I'd like to have "Not Yet Started" as the text entered. =COUNTIF(CHILDREN(), >0) + " of " + [Clock In Location]@row + " (" +…
-
IFERROR(INDEX(COLLECT.... Contains
I am trying to use the below formula to collect LOB based on the Functional unit and Managing office provided. I am referencing another sheet which contains a matrix of Functional Units and Managing offices that fall under certain LOB =IFERROR(INDEX(COLLECT({LOB}, {FU}, CONTAINS([Functional Unit (Dept ID)]@row, @cell,…
-
CountIFS for smartsheet (Excel formula translation to smartsheet)
I have an excel formula that calculates the the number of days by month and status. =COUNTIFS($E$1:$E$100,">=Aug 01 2021",$E$1:$E$100,"<=Aug 31 2021",$G$1:$G$100,"=Not Started") When I translate this formula into smartsheet it does not work. =COUNTIFS([End Date]1:[End Date]100,">=Aug 01 2021",[End Date]1:[End…
-
Project schedule regarding crew size
In Microsoft project I am able to add crew sizes. When I change the crew sizes, it adds days or subtract days from the duration. Does Smartsheet do the same?
-
Create calendar and dynamic document generator
Hi all, Trying to create a database that does the following: 1 - Each crew member has their own line, and within it you can select what they are doing from a dropdown menu each day 2 - Have a report that summarises who's doing what on a given day 3 - Based on today's date ie 18-8 create a dynamic "Generate Document" form.…
