-
Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
-
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
-
How to Create Time Duration
I have a report where I need a formula to figure out time duration. For example, employee starts at 8:00 am and ends at 9:00 am, I need the next column to tell me 1.00 to indicate he worked 1 hour. I will be using military time throughout this sheet.
-
Formula with range data
Hello, I'm looking to see if anyone knows a formula that would add owner income and co-owner income together to reflect in Joint Income column. I'm not sure how to do this with data in ranges. Thank you.
-
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…
-
New entries to the Smartsheet don't include formulas
Hi all, New entries into my Smartsheet are not including the 2 formulas I have created. I have tried the troubleshooting which advised the following: Ensure the formulas are present in cells near where you want the new rows to appear. Check if the last row before the new entry is indented, and remove any unnecessary…
-
Formula for Resource Type, Resource Name and Year
Hello - We have set up a sheet to pull from a Master document to include Resource Type, Resource Name and Year. The Year is from a Helper column. Can someone review the current formula we have to identify where we went wrong to no pull "zero" as the result vs the actual number. Before adding in the Help Year and Reference,…
-
How can I make FS dependencies start on the same date the predecessor ends?
Hi everyone, I’m migrating a schedule from MS Project to Smartsheet and I noticed a difference in how FS (Finish-to-Start) dependencies behave. In MS Project, when a task has an FS predecessor, the successor’s start date is set to the same day the predecessor ends. But in Smartsheet, the successor is pushed to start one…
-
SUMIFS Unparseable Error
Hi, I'm attempting to use SUMIFS to sum data (Royalty Rate) from another sheet if the Project Number in the other sheet (Project Num) matches Project Number in the current sheet, and if Based on from the other sheet is "SRP". Current formula that isn't working is below. =SUMIFS({Royalty Rate}, {Project Num},[Project…
-
Comparing names from Worksheet A to Worksheet B and Identifying those on A that are missing from B
I have two worksheets. Worksheet A is the master Worksheet B is a collection of months' worth of data-it is populated by a form. I'm trying to write a formula where I compare Names from Worksheet A to Worksheet B and identify on Worksheet A names that are missing from B in the current month. Worksheet B has a column that…