-
Is there a keyboard shortcut to minimize sub categories/tasks in grid view?
I have thousands of lines in a SS with lots of categories and sub-categories with tasks within them. I like to navigate the ss using my keyboard. Is their a keyboard shortcut to minimize categories? For example, can I toggle the "-" or "+" signs on the lines in the attached photo using my keyboard? (see photo) Thanks!
-
Dashboard Report data right justified
I have a dashboard with 4 report widgets. Two of the widgets show the report data right justified. The source sheet and report both show as left justified. Anyone experience this issue? Any idea how to get the widget to show the report data as it is in the report and source sheet (left justified)?
-
Referencing a date from another sheet
Hello, I am trying to create a formula to pull a date from a row on another sheet and show that date. Here is the description of the two sheets: Sheet ‘A’ is tracking shipments for a specific project and where I need the date to show up. This is a new sheet I am trying to implement. Sheet ‘B’ is a list of all projects…
-
using one sheet or multiple sheets
Hi, I am brand new to Smartsheet and want to know how I determine whether or not I put multiple topics on one sheet or on separate sheets. I am working with budget-related topics. For example, I don't know if it makes sense to create one sheet with all phases of budgeting (quarterly forecasting, budget development, budget…
-
email replies not going to smartsheet
I was informed that a co-worker replied to a comment via email, however the comment was not in the smartsheet. I tested this using my work email address and it did not work either, so I also tried using my gmail address and it worked perfectly. I checked with IT and they see the outbound traffic and the email did not…
-
Update email not working
I have a workflow to notify people when a new issue is assigned to them. This has worked in the past but the email side has stopped working. The smartsheet is showing the update request has been sent but no one is recieving any email.
-
Duration Column with Dependencies Enabled
Hi All, So with the duration column, we have decided to enable the dependencies however the calculation seems a bit off To test it we but in 2 days for duration Dependency is Start Date and Due Date We thought that if the Duration is two days. We put in a Start Date of 9/1/2020, then the Due Date should be 9/3/2020.…
-
Counting and Dates
I've created a complicated cross-sheet formula that is supposed to count any number of inquiries I have in a specific month. So, basically, the formula is supposed to count anything in Range 5 (named "Inquiry Date") and calculates the date, entering the total on a separate sheet. So if I have 4/3/20 in any cell in Range 5,…
-
format a cell to be date and time format?
Hi I was wondering if there was / is a way to format a cell to be date and time format? We enter in when we contact a customer for the 1st time and have to track the date and time. It would be nice to do so with one cell where we click the cell and a time stamp of now (but editable) is available. Is this a current feature…
-
Is there a way to copy Summary Fields to other sheets but not overwrite data already entered
HI, I have an issue where we have most Summary Fields that contain formulas but we have a few which are keyed in for integration with our CRM. I have created a sheet with the manual summary fields and another for formula fields but when I copy only the last set of Summary fields are stored. Additionally, when we add more…