-
Change Management: Multiple projects > Consolidate into one
Hi there, I have multiple change projects to track within the general IT PMO along with other non-change projects. My goal is to consolidate them and list them underneath the 'change' category and so I'm trying to figure out the best way to organize them without listing them all out and clogging the other non-change…
-
I.T. Project Management workflow process
Hello, I am new to Smartsheet and have seen nearly all of the training videos, I work in I.T. Cybersecurity and wanted to get your opinion on how to create a Smartsheet(s) for looking at installation, failures, dates, etc. for I.T. disk drives. I have information on an excel sheet that was provided & an initial Smartsheet…
-
Value in one sheet create a "populate" trigger in another sheet
Good afternoon We have a bid invite sheet that we fill out with prospective jobs (each row is a prospective job) to bid on. It has multiple columns of Data that if we decide to bid on the job would need to be transferred to our sales/estimating sheet. If we had a YES/No drop down column and we choose YES is there a way to…
-
Is it possible to look-up information from a different sheet with more criteria?
Hi all, hope everyone is doing fine here. I'm working on a sheet to specify information from a larger sheet. I was wondering if it is possible to vlook-up information with more lookup values? Hope you can help me out! Jordi
-
Formulas seems not to be calculated
I have a big sheet of ~11000rows by 30 columns (an asset register) I added 2 columns to calculate the duplicates =IF(COUNTIF([L2]$1:[L2]@row, [L2]@row) > 1, 1, 0) and to select the rows to show in a filter =IF(AND([DuplicateL2]@row = 0, NOT([L2]@row = "")), 1, 0) Copying/pasting or Selecting + CTRL+D the formulas has been…
-
How can I pull a report- or write a forumula to show me Rows with a specific status?
I have created a sheet that tracks the training status of 20+ team members on ~200 SOPs. Each SOP has its own row and Team members are the columns. I want to draft a report or pull data into another sheet or easily sort SOPs based on Status for EACH team member. My goal is to be able to facilitate compliance by providing…
-
Sheet Linking - Project sheets to single metrics sheet
Hi, I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and analysed. The information & metrics from all projects should be collected in the Metrics sheet.…
-
How can I count the amount of actions in a certain weekday?
Hi all! I'm trying to setup a formula that allows me to count actions (in red) and that also shows me the weekday in which they were made. The columns I'm using for this are 'S' and 'Action Creation Date'. My formula is currently the following: =COUNTIFS(S:S, "Red", [Action Creation Date]:[Action Creation Date], [Action…
-
Dashboard Sharing: Is there a way to check all the Dashboards I currently have published?
Hello, I've created a few Dashboards and published them for viewing. After viewed, I removed the publish option in order to stop anyone from acessing them. Is there a way to check all the Dashboards I currently have published? I wanted to make sure I haven't left any of them out.
-
Problem with average number formula, with certain criteria
Hi All! Im trying to get the average number of a certain range, but only if it meets a certain criteria. I have looked at other examples but somehow i don't get it to work. So I want the average of the blue columns. But only if the Red column is a certain name. And if its possible I want to do the formula on a seperate…