-
Report that not required to manually adding up new project
Hi Team, Can someone help me how to create a report that doesn't require to manually add when we have multiple projects...Is there a way.? Regards, Tanveer
-
Vlookup person on other sheet, return reference if a date falls between 2 other dates
Hi all, I need help with the following: I need to find the contract reference of a person from Sheet 1 in Sheet 2, based on the name of the person and when the mission took place. As you can see below, James had a mission on the 16th of April, so I need the contract reference that corresponds to that date, which would be…
-
Using templates vs sheets in "template set"
Hi, I am creating template "sets" similar to what SmartSheet has created so that our workplan has the same related reports and dashboards for every project. Because we have a lot of users, I like the idea of having the main workplan in a template so that it cannot be overwritten. However, I noticed that in none of…
-
Smartsheet dashboard view
Hi Team, Can anyone suggest me how to create this kind of view in smartsheet.
-
Sales Pipeline - Period View
Hi, I have a few sheets of Sales Pipeline for each Manager. I have brought all of the estimates sales data together in a separate sheet and created a Dashboard using this. However, I would like to only see data relevant to the particular Financial Year in the dashboard. Any suggestions on how to go about this?
-
Renaming sheets with different versions and impact on reports/dashboards
Hello everyone. I am still transitioning our documentation over from our previous process to SmartSheet. In our current PM processes, our project artifacts (actions, risks, etc.) are all contained within a single Excel workbook as separate sheets. This workbook gets renamed each week so that we keep track (or in case…
-
Auto delete unwanted rows
Hi All, is there a way to auto delete older records from a sheet without manual effort. I know we can use copy or move rows depending on dates but still it moved to other sheet. I need rows to permanently disappear if its outdated. Any suggestion much appreciated!!!
-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
If Statement
Hi Team, Can anyone help me how to write this condition In Smartsheet Thanks
-
Can we have chart in sheet like we do in excel
Hi There, Can we have chart in sheet like we do in excel I dont want dashboard I want the chart % to be in sheet column Thanks
