-
Question on copy and pasting - keeping formula formats
Hi All, Wondering whether I can get any help with my question below. I have a sheet showing data in relation to a particular investment - lets call it Investment 1 , the formulas are working ok. For the following set of data, i.e. Investment 2 I want to use all of the same formatting as used for Investment 1, so haveā¦
-
Linking Schedules to a Master Schedule
Hi Team, My company has a master schedule that is at project phase level (Initiation, Planning, Execution, Monitor & Control and Project close. Is it possible to link in the project schedules (which have the same roll ups) to the master, so that % complete and dates that are rolled up in the project schedules update theā¦
-
SUM within a date range
Hi, I have 2 columns, 1 is a purchase amount, and the second is a purchase date. I'm looking to create a table from this that breaks down total amount purchased by quarter. I've tried the following among a few other variations with no luck: Q1: SUMIFS([Purchase]1:[Purchase]34, [Purchase Date]1:[Purchase Date]34,ā¦
-
Automatic date fill
Hello, I have the below columns and I would like to add a date column that automatically fills as the days change. is that something can be done?
-
Working with Pictures and Index/Match Formula
Hi, I am building a product basket / configurator where I have a printer engine and I want to add accessories using checkboxes. This part is easy, no worries there. I have a sheet with all the device info I want to use, this is referenced with a cell link, and to start the configuration I select a SKU from the list usingā¦
-
Why does Smartsheet not allow multiple duration columns?
Use Case: Want to log current duration and optimal duration of a task. Want to represent conveniently and have easy roll up. Current situation: Have write formulas and use number column. Sub par experience compared to duration column.
-
Invitation not being rec'd
We recently purchased 10 licenses but 3 of my team members have not rec'd my invitation despite sending it multiple times. We all have the same domain..@rx.umaryland.edu. Any suggestions?
-
Have cells inherit background color
So, I have a helper sheet that tracks Budgeted, Committed and Actual spend for an individual project based on the end date from a project sheet. The sheet is laid out where a total of 24 months have their own columns in chronological order from left to right. There are four rows for Budgeted, Committed, Actual and the lastā¦
-
Is there a limit to the number of users you can share a sheet to?
Hi, I have the Business plan.Ā Is there a limit to the number of users you can share a sheet to? I have received a message that there is a limit of 100, but I believe that that plan has unlimited. I am trying to share with 180+ users. Thanks.
-
Sending Line Item Information
Is there a way to send the information on a line item on a Smartsheet, along with notes and attachments, to someone else via email? What are the requirements necessary to be able to do that and are there different options available?
