-
copying rows to another sheet
Is it possible to set up automate action to copy certain rows when check box is checked ?
-
IF FIND RIGHT String
Hello, I’ve been searching all over the Smartsheet community since last week and was hoping someone could offer some assistance. I have a long Status value that I need to auto populate a shorter value in another column. I really just need a contains formula but I haven't seen that as an option here. I could do this for the…
-
Create charts without hidden data
Is it possible to create a chart without including the hidden data?
-
Help getting started
I am very new to smartsheet and am only day 3 of using the tool. I am looking for some guidance or confirmation in my approach to manage the projects of my team. I have about 53 team members and everyone has anywhere from 5-30 projects that are either being actively working on or are in the pipeline. I am looking for the…
-
New version of Smart Sheet
Do you know when exactly in April new version of Smart Sheet will be released? I was trying to find any information about that, but in vain. Is there any doc specifying what has been changed and what functionalities would be added ?
-
How to use data from another sheet as selection criteria?
Hello, I am trying to build a Report or ANOTHER sheet where I pull data only for Rows from another sheet that have OrderNr=OrderNr from the other sheet. The ordernumbers change daily. I need to be able to refresh automatically on a daily basis. Any recommendations how I should approach this?
-
Define working days without affecting the calendar
My team travels for business frequently and we need to keep track of the weekends they have traveled on so everyone can get their days in lieu. I used the NETWORKINGDAYS formula and it looked fine. The problem is our weekends are Friday-Saturday instead of the regular Saturday-Sunday. If I enable dependencies to configure…
-
Any limits on the number of dashboards?
Hi, Are there any limits to the number of dasboard a user can create? Many thanks, Grace
-
Cross sheet formula - help
With this new feature I'm hoping I can eliminate abut 10 columns from one sheet and create a sheet just for totals. Currently I have several columns just for counting the value of columns with checkboxes. Do I have to leave these in the same sheet? When I tried to do the values in a new sheet by referencing the main sheet…
-
Referencing sheets
I am trying to decide between one sheet vs multiple sheets. I currently have one sheet but it has over 50-60 columns and there are sets of data that will be used by different areas. I know I can filter what is needed (to a point) with reports but it still doesn't give me the end result I need. Here is the breakdown in a…