-
Target Start Date setup as a queue
I am looking to incorporate a dynamic target start date into a sheet. Essentially as a task completes it needs to reference an assignee, project ID, and the end date of a task to assign the next target start for the next task. I keep confusing AI when I try to generate this. Anyone have any experience with this or am I…
-
CountIF <> "#NO MATCH"
I'm using the Linked Columns tool and every unmatched result is returning #NO MATCH. This wouldn't be a problem except I have a formula that counts the number of columns with a value and checks this against the expected number of values to determine row status. My previous Count(columnA:columnZ) doesn't work, and I've now…
-
Monthly Count of Request Types
Good day, I am looking for a formula that can count the number requests of a certain type in the current month. For example the two columns I have are "Request Type" and "Request Created." The request created is the standard request created column built into Smartsheet. The "Request Type" column has multiples types say…
-
How calculate hours
Hey all, I am new to Smartsheet and trying to convince the hire ups that excel is not good for reports. I can't seem to find an answer for this issue for this sheet I am trying to put together for a demo. Please see the screen shot below. I work for an airline and we are trying to build a report to see how much time we…
-
Formula required to count risks not updated in 14 days
Hoping someone can help - I want to be able to count the number of risks in a risk log that have not been updated in 14 days. I thought I would be able to do this using a modified date column until I realised the date appears to update for things like automations so it is not giving me an accurate figure! Any help…
-
Help with Index & ROW
Hi, I have a sheet with the Master List of projects, which includes all Fiscal years. This sheet contains Project Year, Location, Start and End Dates, etc… Major metadata associated with the project. I have another sheet, where I would like to get more granular and tailored for various functions such as Permit Tracking,…
-
How to have each subsequent value that matches a criterion appear in its own cell in a column?
I'm trying to pull change order numbers that are assigned to one specific person in a source sheet appear as separate entries in one column in another sheet. I've gotten it to manually work with this formula: =INDEX(COLLECT({CO Number}, {Assigned PM}, "PM Name"), 1) But I have to manually adjust the number at the formula…
-
Counting Error
Hello! I made this awesome spreadsheet to count the hotel rooms per night to give to a hotel but when I go to summarize the column to count the totals I am getting an error. I think its because if a cell is blank for some folks the formula returns "invalid operation" which in turn effects counting the TOTAL cells to get…
-
Pulling Data from One Sheet to Another
Hi This is a really simple question - I want to pull the answer from one sheet with a number in one exact cell to another sheet so I can reference that number and compare. Seems really simple but I cant figure it out. I think its v look up or index/match but they seem to want me to look for a range, this isnt a range this…
-
How can I get around the 500 cell link pasting limit?
I keep running into the 500 cell link limit which is rather frustrating. This happens when I use "Link from cell in other sheet" menu option. I'm trying to duplicate a sheet so I have the latest information. I can do it without the cell link, but I would run into the same issue. It's frustrating because in the Link from…