-
Displaying multiple time periods in Gantt view
Is there a way to display multiple time periods in Gantt view? Example: you have staff members that are your primary people, and they are contracted for 4 months, and then secondary or "fill" staff members that sit in when the primary is away on sabbatical or similar break. Idea here is that the gantt bar on a given row…
-
Week Number Year to Year
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
-
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
-
Batch Sheet Creation from Template
Problem: Current Limitations Manual Repetition: Provisioning a large project (e.g., 50+ distinct team sheets) currently requires manually executing the "Use Template" or "Duplicate Sheet" workflow 50 separate times. Time-Consuming Setup: There is no native bulk-action to instantiate multiple files at once, creating a…
-
Forms & automation
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
-
IF Formula Not Working As Intended
Hi everyone! The below formula is not populating a 0 in cells that are new, as intended. The AI tool even says this formula should work, but it's not. After staring at it for hours, I can't figure out where I'm going wrong. Your help would be greatly appreciated!! Thanks! :) =IFERROR([Date Logged]@row - MAX(COLLECT([Date…
-
Help with a function to collect data from 2 different sheets based on year date
I need to extract information from 2 different sheets based on the name of the member organisation and the join year (i.e. DD/MM/YYYY). The 2 sheets have the same column titles, but one is for 2024 and another one for 2025. Where organisation joined earlier than 2025, then it needs to fetch the data from the 2024 sheet,…
-
Collect Data Based on Today's Date
Hi all. I'm trying to do something that I'm not sure if it's possible or not. We have a sheet that we are importing where the first column lists areas within our factory. Each column after that has a column name of a date. So 12/15/2025, 12/16/2025, 12/17/2025, etc. In each of the date columns is a target production…
-
SUMIFS using Dropdown
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
-
Has anyone used remote staffing (like CrewBloom) to support Smartsheet workflows?
Has anyone here used remote staffing support (like CrewBloom) to help manage Smartsheet projects more efficiently?