-
Clone a widget to another sight?
I've got a nice set of KPI's pulled together on a 'demo' sight that I was reviewing with my team. Now that we're happy with the look and feel, I'd like to publish them to a different sight for a broader audience. I know there's a 'clone' button. I don't see an option to 'clone' a widget to another sight. Is the only option…
-
Scheduling an Update Reminder like an Alert
This is a test sheet (screenshot attached). I am trying to set up a method to where an Update Request is automatically emailed to the sales rep 3 days after the trigger date (Bid Date). This functionality is in the Alert Module, but in the Update Request you have to manually set a date each and every time; keep in mind I…
-
Report Builder - Pull projects completed one year ago (month)
I would like to auto-run a report of projects completed over the course of a month one year prior. (i.e., the report would tell me on August 15, 2017 what projects were completed between August 1 and August 31 last year). I plugged in report builder that the column I want it to filter by (Actual Completion Date) should be…
-
Auto-Copy Formulas
I was having some problems with standard =this+that*something formula not copying down when I add a row. When I add an IF() statement to the formula, it seems to work. I noticed this, because all of the IF statements in other columns were working, so I thought I'd test the theory (add the IF()), and it worked. Anyone else…
-
Dynamic Allocation % / Resource Management
Monitoring RM (Resource Management) is pointless if the data is inaccurate! Current “Allocation %” is static (if RM is enabled) making RM data inaccurate! Please LIKE or bump if you agree that we deserve a truly SmartSheet w dynamic content! “Allocation %” should be able to accept a formula. Currently when you turn on RM…
-
Filtering with Start and End date views
I have filters setup to view different tasks on separate calendars. However it only shows the StartDate. Is there a way to enable EndDate as well?
-
formula for date to land on the following Tuesday
Hello, I am calculating a date based on another date: =[Proof to LSI]70 + 49 I would like to add to this formula so that the date will always land on the following Tuesday. Any suggestions? Thanks, Kim
-
=IF formula ???
I am trying to create an alert formula. I need to contact people every 15 days. I have one cell that states "Last contact" and the date, another that states "Next contact"and the date, the third cell, I would like it to state "Contact" in red. Can anyone help me formulate the "Contact" cell?
-
autofill linked cells
I have a Master sheet with job rows that number 1to17, next job starts on 18 and are the same rows of data. These continue as such for subsequent rows. My other sheets link to certain rows on this Master. For example row 17 is always "Shipdate", so my "ShipDate" sheet links to row 17 on each job so I can have a calendar…
-
Shared reports are blank
Hello, After performing a search I ran across many others users running into shared reports showing up as blank pages. I tried the solution I ran across and assured that the user also had access to the sheet the report was made from. And still I am seeing a blank report. Was this ever corrected in early/mid 2016? I am…
