-
Stale time/date
Hi, I am trying to setup a "Stale" notification for a help ticketing system. When a support ticket (row) ticket has not been modified when compared to the current time and date in over an X amount of hours, then send a notification. I can compare two different date columns like this: =Modified1 - [Created Date]1 But if I…
-
Removing duplicate types in an output report
I have a report that shows the output of staff within a department. It shows all the publications and events they are working on. I am looking to build the report so that it does not show duplicates of the same type of output by the same person. For example, Staff member A is running 10 roadshow events throughout the year.…
-
Smartsheet and JIRA integration
Hi, I have two questions related to Smartsheet and JIRA integrator and I'd like to know if somebody here could help me: ** Question #1: Is it possible to insert a row (automatically) within a parent structure from JIRA integration? For example, suppose I have this smartsheet: Marketing Team Tasks Task 1... Task 2... Task…
-
File Upload from Customer into their Designated Row
I was hoping somebody could help. I have a form set up where customers can upload their artwork directly to our sheet and once checked I send an approval request as a proof. However if the proof is declined or we check the file and it isn't print ready we require customers to upload a new file (artwork). I have tried this…
-
File Upload from Customers
We have recently started using smartsheet to organise our print jobs and workflow through the production line. I am curious to know if a customer that doesnt use smartsheet can upload artwork into our sheet? Can we send them an upload link where customers can upload their artwork (PDF) into their specific row on the sheet?…
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Need to set a date with formula whenever new task is entered
Hi. Among the other columns i have 2 columns named "Task Name" and "Start Date". What i would like to create now, is whenever new line is entered to "Task Name", the current date will appear automatically to "Start Date" row and date should remain as date when task was entered. I tried following: =IF([Task Name]5 > "0";…
-
Tracking boxes checked per user per day?
Is there any formula I could use that would track the number of boxes checked by individual users for a specific day? I know I can generate this data in a report, but I'd like to create a formula so I could build around it.
-
Automatic reminders based on dates
Hi All, very new to smartsheet so please be kind :) I have a requirement whereby I need to badger suppliers to ensure that they will deliver on schedule, so I'm hoping to do the following: Add a column for expected delivery date Add a tickbox for "will require chasing" Have a reminder automatically set to trigger at 50% of…
