Using Smartsheet
Archives for April 2019
Discussion List
-
Sheet CompareIn Using SmartsheetI receive a weekly report that I need to compare to the previous week's report to determine what changes have been made over that week. If possible I would like to be able to do this compare in SmartSheet (instead of using Spreadsheet Comp…
-
Requiring Approval when Dates ChangeIn Using SmartsheetHello community - I currently have an approval request enabled that notifies me via email once a day whenever a date in the Due Date column is changed. I also have a dashboard that shows me whenever an approval is needed and would like to…
-
Administration controlsIn Using SmartsheetGreetings, I am looking for advise. I am new to Smart sheets and my Operations manager no longer works for my company and she is setup with all of the administrative controls. I need to gain administrative control of the account. can anyo…
-
VLOOKUP reference another sheet with parentsIn Using SmartsheetWe are looking to create a formula to reference a date in another sheet (sheet 2) and than see if the referenced date in (Sheet 2)is before or after the date in the formula sheet (sheet 1). Forcing a check box or adding a visual identifie…
-
countifs formula to sum not blank datesIn Using SmartsheetHello ~ I'm new to the community and working with the COUNTIFS formula. Help would be much appreciated if you can see the error of my ways. What I want to do seems simple - I have a "Date Completed" column, defined as a Date type…
-
Approval Alerts & Actions -Column Data visibilityIn Using SmartsheetWould anyone know how the approver could view certain column fields? I tried the Advanced Option and checked things off but it still does not show the data in the columns I checked off.
-
Claims Denial ManagementIn Using SmartsheetHello. I will be working on building out a claims denial management work plan but was wondering if one already existed within the abundance of templates?
-
Estimated DurationsIn Using SmartsheetI ma moving from Microsoft Project to Smartsheet and trying to replicate workflows that have served me well for decades. In Microsoft Project, I can indicate that a duration is a estimate by including a question mark, for example 5d?.I us…
-
Contact not displaying name on Assigned To fieldIn Using SmartsheetWhen I try to add one particular contact that I added to my contacts list to the Assigned To field on a Gantt chart, it won't display the Name... just the person's full email address. This is only happening for this one contact - the rest …
-
Tracking Time (Tasks)In Using SmartsheetGreetings, Looking into the prospect of getting my engineers to enter time spent against tasks in addition to 'guessing' and their percentage of completion. It seems the threads here are all a couple years' old or more - wondering if the…