-
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…
-
#CanDoCommunity Live Q&A: Learn from your peers - Smartsheet for Higher Ed
Tuesday, Sept. 15 from 9-10 a.m. PDT Join us for a live Q&A session on September 15 at 9 a.m. PDT with three Higher Ed subject matter experts from two major universities! These three Smartsheet champions hold leadership roles at The University of New Mexico and California State University - Fullerton. They oversee a wide…
-
SUMIFS with multiple OR criteria using CHILDREN?
Just curious. Looking for a way to speed up this scenario: =SUMIFS([Range to sum]:[Range to sum], [Criteria range]:[Criteria range], OR(@cell = [Criteria]1, @cell = [Criteria]2, @cell = [Criteria]3)) Is there a way to transpose that OR statement into something using CHILDREN so that I can plop a list of a large number of…
