-
How can I improve/automate my workflow?
I currently have a sheet with Smartsheet Licensed Users in our company, we want to check the last time each user logged in to Smartsheet so that if we think they do not require a license we can remove it from their account. I currently do this by generating a User List Report in the User Management section of the Admin…
-
Join Collect
Hi I'm trying to to create a sheet that tells me all of the timekeepers that work on a client from data from another sheet. Currently I have sheet that list all of our clients and I will like to add a column that list all of the timekeepers that work on the project. Normally I would use Index Match however, some clients…
-
COUNTIFS with vLookup Results
When i reference the VLOOKUP fields in the COUNTIFS formula, I get this error #NO MATCH. =COUNTIFS([Server Install Status]:[Server Install Status], "Installed", [In Scope]:[In Scope], "Yes") The [Server Install Status] column is populated with the results of =VLOOKUP([Server Name]1, {cmdb_ci_win_server20200810 Range 1}, 3,…
-
Create multiple rows based on data from one cell
I need a way to count the number of states each project participates in. For example, for Project A I should be able to says West Va and Va. Smartsheet will not allow me to count the state column. So I would then like to be able to separate each project by row based on the state column. I found VBA code to use in Excel to…
-
IF Formula doesn't work
Please help, what's wrong? It couldn't be parsed... =IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4); ([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4));"ДА";"НЕТ") Thank you in advance.
-
Does Smartsheet allow the calculation of IRR?
I have found a key element of Program Management that needs solution in the Smartsheet platform. The calculation for IRR is critical component and not available as general function. As you may know, this simple one varying net cash flow typical program. Does anyone calculating real-life program can share with me?.
-
Auto Assign Contact Based on another column's content
Hello, I would like help with creating a formula to auto assign someone to a row based on who was originally selected. In this example, I want to manually assign an officer and have the Team Lead & Front Office Support to auto populate answers based on who was selected as an officer. Both Team Lead & Front Office Support…
-
How do I display a Max Date for Child Tasks only if there are no blank Children?
I have a sheet with many hierarchies of Parent and Child Tasks. I want to display the Max Date of the Children, but only when there are not any blank values for the Children. Objective 1 - Completion Date 8/10/20 • Task A - Completion Date 8/7/20 • Task B - Completion Date 8/10/20 Objective 2 - Completion Date TBD or blank…
-
Can Index Match pull multiple records?
I am trying to pull contract numbers from an Active Contract file over to a 2nd file using the customer name as the unique identifier which is working just fine via INDEX(MATCH), however, if a customer has more than 1 active contract it only pulls the first one over. What's the best way to pull all of the contract numbers…
-
Copy Rows to Build a Master Sheet out of Individual Sheets
I have ~40 project info sheets that are structured with columns to populate roll up reports for a portfolio-level executive 'dashboard'. These info sheets also have sheet summaries referencing the 'active status' and populating a dashboard with that content. I want to on my executive dashboard capture metrics (but can't do…