-
Is there a way to distinguish if a row is subtask or not?
Quiero que en una columna se muestre un icono sólo si la fila no tiene subtareas ¿es posible con una fórmula? Gracias **Google Translate by Moderator** I want an icon to be displayed in a column only if the row has no subtasks, is it possible with a formula? Thank you
-
How to keep a cell blank if there is no data?
I have two sheets a master (2800 records) and a feeder (270 records). I am using the following formula to update a column called scheduled date on the master: =INDEX({feeder06262021 Range 1}, MATCH(IP@row, {feeder06262021 Range 2}, 0)) Which works bringing the date in, however the majority of the cells on the master sheet…
-
Forumla help pls
Hello, I'm trying to create a dashboard or even a simple sheet that will pull data from my main sheet. Essentially I have a master sheet with Merchant info, Sales Person, Payment Status, and Application status(done or 1of 5 other statuses). I want to pull data from my main sheet so it's easier for the Sales team to quickly…
-
Count if Column has a date
I'm trying to build a ship status sheet and use the sheet summary to give me a count if a certain column has a date. something like: =COUNTIF([Estimated Ship Date]12:[Estimated Ship Date]22, (ISDATE(, "1", "0")) but all i can seem to get is UNPARSABLE
-
Conditional formatting for entire sheet instead of columns?
I have a grid set up to track the status of 12 different steps in a process for 10 items. The rows list the individual items, the columns track the status for each step. I want the cells to light up based on the status - Not Started = grey, In Progress = yellow, Complete = green, Having Issues = red. Is there a way to do a…
-
Find the unique dates from a sheet AND display them from oldest date
From a previous post I can find all of the unique dates from a sheet within the last 45 days. My problem is that the dates are not listed from oldest to newest, so when I add this information to a dashboard it does not display correctly. Here is the formula I'm using: =IFERROR(INDEX(DISTINCT(COLLECT({Column 1}, {Column 1},…
-
#INVALID OPERATION Error
Question: Is it possible to write a SUMIFS column formula to add up specific cells in an adjacent column where the criteria are also in other adjacent columns? (Actually, I know it's possible, because the formula I wrote a couple days ago worked just fine at first, but it's refusing to work today, and I don't know why. The…
-
I need a form to auto populate in some cells from another sheet. Could you help? thanks
I need a form to auto populate in some cells from another sheet. Could you help? thanks
-
Search on a text string to return all values
Hello My Fellow Smartsheet Gurus, Is it possible to run a formula based on the text inputted in the column next to it to pull all possible values? I am trying to accommodate multiple ways of finding medication names where an exact match is not always possible? If so how would accomplish this? Thanks so much in advance!…
-
Is there a way to prevent cell value assigned by formula from changing after sorting?
We need to assign a number and letter combination in each row of a sheet. Some rows are considered to be "in a series" and will need the same number but a different letter, i.e. 40001A, 40001B, and 40001C. We have a formula that will assign the letter based on the count of the number, i.e. the first time 40001 is entered…