-
Help Please =IF(TODAY()
=IF(TODAY() - [Expected Close Date]2 - 90>120, "3-6 Mths") If todays date 08/09/2017 Nz or 09/08/2017 Us (Built in calendar in Smart Sheet) looks at the date I entered in to my Expected Close Date column 14/02/2017 Nz or 02/14/2017 Us then it will return "3-6 Mths" being that 14 Feb date is between 90-120 days ???? Am I…
-
Project Parent Hierarchy not shown in PowerBI
Hi there, I am trying to connect Smartsheet and PowerBI, so that I can visualize data in PowerBI from Smartsheet. I have the connector working, and can pull data from Smartsheet, but it pulls the basic data (row level) for all rows with no way of distinguishing a child row to a parent row. So where I have roll-up…
-
Notification in Template
I created a notification and saved the sheet as a template. When using the template to create a new sheet, it retains the notification but not the email address in the notification. I set the original sheet to use any email address but apparently that setting doesn't transfer to the new sheet. Then I shared the workspace…
-
Export to Database
Hi, I wish to store the data on my smartsheet to a local SQL database. How do I go about doing this? We need this to create metrics that can track time taken for approvals etc.
-
Mobile App Update Requests
Is it possible to track update requests in the mobile app? I know we can send update requests from the app. But, I don't believe we can view update requests that have already been sent. Please prove me wrong! Thanks, Dustin
-
Workspace sorting/hierarchy
I have a bunch of workspaces (each with neat organization setup inside them), but I don't see a way to sort, group, or create a hierarchy to the workspaces. Since I use Smartsheet both with my own company and with my clients, it would be great to have a way to "group" the workspaces so I can have "internal" and "external"…
-
Need help with date range overlap formula
Please see attached screenshot. I use the "Duplicate" column to show whether or not there is an overlap in the date range between new entries and the "Start Date" & "End Date" columns. In Excel, the following formula works great: =SUMPRODUCT((D2<enddate)*(E2>=startdate))>1 I know that Smartsheet doesn't support SUMPRODUCT.…
-
Sheet Speed problem
I have a sheet we are using to track payments etc with the layout is simple First Col is the Colored dots Red/Yellow/Green Cols 2 to 7 are just plain data 3 are date fields the rest are text Col 8 has the only formula = TODAY() - [Check Date]1 However the issue is the speed of the sheet, it acts very sluggish and the first…
-
How to avoid duplicate entries in a report due to linked cells in multiple sheets
I am close to creating a calendar (report that only shows activities across sheets with duration < 15d), but have run into an issue where certain activities or milestones are showing up twice because they are linked between sheets. Other than manually identifying these linked cells (checkbox, etc), any ideas for a more…
-
How to count the number of rows of the children?
Hi guys, I spent a whole day searching the forum but didn't find any relevant answer. I need to know how many children rows a parent have to do some calculation. So it's not about the content/number/text in any cell of the children rows, but the NUMBER OF CHILDREN ROWS(no matter what's inside them, even if they are blank).…
