-
Permissions to only view certain rows in a large task list
We have an extensive "Mastersheet" for each of our projects that contains a lot of information. We also have outside partners that we want to give permission to view only SOME of the rows in the Mastersheet. Is there a way to do this without creating a report? The report becomes confusing because it doesn't indent to show…
-
Cut and paste form a word doc into Smartsheet cell
Why is S not letting use C&P? I'm a part of a large project that uses Smartsheet.
-
Free Smartsheet Advance Webinar: Intro to WorkApps
Join us on December 8th for a free webinar "Intro to WorkApps" in this webinar we will be learning about how to create and share a customized experience of data, content, and resources, based on roles with WorkApps. We will be hosting 3 sessions across multiple timezones, if you are not able to join us live, feel free to…
-
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,…
-
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.
-
Automated Workflow --Multiple conditions with And Function--
Hi, I am trying to create an automated workflow with two conditions and I want those two conditions to be met at the same time, however, I can't seem to switch from "Or" to "And". Notification Type is alert someone and Trigger mechanism is when rows are added or changed. Thank you in advance for the support
-
Gantt chart line for overarching group within a report
Hi All, I have report fed by a data sheet which contains dates for departmental events. These are grouped by department. I have added a Gantt chart which displays the individual lines but i'm wondering if it's possible to have the Gantt data roll up into the grouped Department line. For example, Department A has event 1 on…
-
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…
-
Links do not Work
Whenever I publish a Smartsheet, all the links that are in the form of => Open as Smartsheet item does not work, please let me know a workaround on this as it's Important to publish the sheet and also cannot do static linking, Thanks!
-
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…
