-
Sum if match formula
Hello, I am looking for a fairly complicated formula (I think). I have two sheets: 1) IW POD and 2) Root Bushing Repair Tracker on sheet 2, I have a column named "Actual Execution Hours" In that column, on sheet 2, I need to sum the hours on sheet 1 in column "Total Actual Hours" IF these two columns match on both sheets -…
-
Formula working for one data value but not another
Hi Community, I have a sheet that contains, among others, columns titled "Priority" and "Contract ID". Multiple rows can have the same Contract ID and the same Priority. Priority values are 1-2-3 and restricted to dropdown list values only. To collect the number of unique Contract IDs that are Priority "1", I have this…
-
Need Help With Date Calculation Formula
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
-
How to create a day countdown from starting date
I am looking to have my sheet track the number of days remaining after a beginning date entered in a column (labeled Conversion Date). I need to know how many days are left from a total of 90 days.
-
Managed vs Unmanaged Resources Utilization Reports
I have linked my Project Plans to Resource Management but the Utilization report in Resource Management is only showing me the Managed Resources and does not show me the Unmanaged Resources. Is there a way to get this Utilization report or view without having to buy Licenses for all these Resources who will not use the…
-
Soumitra Dutta-How do I get started with Smartsheet?
Hi Everyone, I'm Soumitra Dutta – Entrepreneur & Photographer Based in Oxford. I’m new to Smartsheet and want to get started using it effectively. Could you share your tips, recommended tutorials, or best practices for beginners? Any advice on how to set up my first sheet or manage projects would be really helpful. Regards…
-
Automation of Weekly Updates
Hi all, I have a Smartsheet that I use to track multiple document requests for multiple clients. I need to provide updates to client contacts (sometimes more than one, and they may have more than one client connected, but the updates should be by client) that are connected to each client on a weekly basis. I'd love to…
-
How to Add Guests to a Workspace?
I have recently upgraded my subscription to a Business plan, which gives allowance for unlimited Guests. However the team that I already have added to the sheet are limited to Viewer access only and I am not seeing an option to change their designation. How do I make someone a guest?
-
Add additional items to existing formula
I wish to ADD the following to my existing formula: [Reporting Period]@row="Jan", "Jan" [Reporting Period]@row="Mar", "Mar" [Reporting Period]@row="May", "May" [Reporting Period]@row="Jul", "Jul" [Reporting Period]@row="Sep", "Sep" [Reporting Period]@row="Nov", "Nov" Here is my current formula: =IF(CONTAINS("-",…
-
Importing from Excel to Show Changes from Prior Import
I have an Excel spreadsheet that I need to import into Smartsheet. The Excel sheet is generated every couple weeks, which means some of the data may change from version to version. Once I create the initial Smartsheet sheet, is there a way to only re-import the data that's changed, or do I need to create a new Smartsheet…