-
Calculating complete dates with calendar days but....
I've brought this up before and at one point I thought that I found a great work-around. I would like to use calendar days in my date dalculations but, not have an end date land on a weekend. I created a complete column and with the use of a formula I tested the end date for a weekend and if it was a weekend I boosted it…
-
Send Row to another sheet (not via email)
I have multiple sheets with similar columns, and I'd like to be able to send rows between sheets easily. I know I can just cut and paste, but is it possible to make a button or other similar automation that moves the row from one sheet to another? The Send Row function looks close, but I can only find documentation on how…
-
Common Picklist
Is there a way to define a picklist with values and then leverage that sinle picklist on more than one sheet?
-
Record of Sent Email
Once i've sent an email to 'all shared users', is there a record kept within smartsheet of that email being sent?...i have looked, honest!
-
Baseline
How can I establish a baseline in smartsheet? I am using smartsheet for construction scheduling. Like many industries there are delays. However, in construction delays come with a cost, a dollar amount that needs to be paid when projects go over their time line. I establish my schedule when I start a project. Throuhgout…
-
Smartsheet connect to Tableau
Hi, I am trying to establish the connection between Tableau and Smartsheet. However, I do not have Admin Access to the smartsheet, And, I am not able to connect/configure ODBC using either username & password or the API Connection. Is this because I have 'single sign on' for the smartsheet or do I need to have the Admin…
-
Days Since (Single Date)
I have to do some invoicing and want to know how many days since an invoice was issued. I can sort out how to find the days between two dates but I only have one date to work with here. Would love if someone could help!
-
Report - sum a column
Hi all, I have multiple budget spreadsheets and a related report which I point to one budget sheet at a time. I can then report on just one month at a time (example: project A, October totals). Is there any way to sum the cost column for the items returned in the report?
-
Email reminders not working properly
Hello, I am having issues with the email reminders not working. We use Smartsheet to hold all of our contract due dates. I want to be able to receive an email 30 days before a contract is up. So I created a column that is a date 30 days before the due date, and set a reminder to go out when that date shows up in the…
-
Gant Chart Time Dependencies - Hours
Please let me know if anyone has figured out how to get the gant chart down to hours. The minimum that I have seen is at days and then it goes to weeks, months, and years. We have a project that will have dependencies on certain days that go down to the hour.