Hello! My formula skills are pretty basic so I feel like this might be a bit more than that. I am trying to calculate the number of tasks for four departments across multiple project plan sheets. I wa…
I need to reference another sheet to join and collect the skills of employees. The yellow is my desired outcome, and I'm using the following formula. Formula: =JOIN(COLLECT({Detailed Resource Data Mas…
I am in Victoria, Australia and I am using a form to populate a sheet. I want to automatically populate the Inspection Date to be the date the row was created. I am using the formula =created@row The …
I cannot for the life of me recall how I set up metrics sheets when I was at my previous company! My circumstance is that I have approx. 150 TDLs (they are like account #s), each with their own sheet …
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. T…
I am trying to put together a list of our project managers and which business units each of them are responsible for. I need it to be in a certain format because right next to each of the business uni…
I imported an Excel file into Smartsheet, and am stuck trying to convert this Excel formula into a functioning Smartsheet one. I know some of these functions are not available in Smartsheet. However, …
Hi all, I'm hoping someone can help me with my specific issue that I cannot seem to resolve. In our Workspace that is set up through control centre, we have a sheet called a Checklist that is populate…
Hello, I am working to streamline my project timelines for quicker daily tracking. I currently have a formula based on the task completion % and end date that gives a status and conditional formatting…
I have a formula that creates a note and within that note is a sum of numbers. For example, JOIN("This is your total: $" + round(sum([Number1]@row, [Number2]@row), 2)) When I use this formula, the res…