-
Missing Column Criteria from Report Builder
Hi, I have been working on a report builder for a number of sheets from varying projects to show specific items. Understanding that I need to have consistent column names across all sheets, I have gone through the trouble of formatting them all. My issue now is that when I go to the report builder and I want to add more…
-
Process mapping
Does anyone use a process mapping tool such as Visio or TaskMap that can integrate well with Smartsheet?
-
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?
