-
Multiple rows created within an intake sheet with only 1 form submission
Using Smartsheet for QC sample submission. Some end users may have 10 different samples to submit- having to fill out the form 10 times is not an efficient use of time and there are many redundancies in each entry. Would be great for entry of one form fillable field to be able to have multiple lines of text that are then…
-
New Employee Onboarding - Forms
Hi - I'm using the Employee Onboarding template set. I want to set up a form within the sheet that managers can fill out with the applicable info: Employee Name Manager's Name Start Date Job Title I want these to populate directly into the sheet from the form The challenge is, because these are row and not column entries,…
-
How to combine cell change notification and Data Shuttle
Hello Community, does anyone has an idea to solve the following problem? I have a data shuttle running every night, pulling information from an excel spreadsheet into a sheet (let's call it sheet 1). Do to the fact that there is no unique identifier in that Excel sheet, Data Shuttle completely replaces all the entries in…
-
Calendar App with Date Range Issues
Hey everyone. The Smartsheet Community has been so helpful through the process of building a solution to manage our workforce and the hours on our jobs. We are looking to expand our functionality to include a calendar view, but fear all the work we've done will need to be undone in order to create a usable calendar view…
-
How can the name of the approver auto populate into "approved by"?
We have a change order request form for our suppliers to use when requested a change in the design or scope of our projects. I have an automatic workflow to send the request for approval to our construction manager(s). When they approve (or deny) the request, the status changes to approved (or denied) .. but I cannot seem…
-
Entry date/Payments
I have a sheet that tracks payments made by certain clients. When I add a new client that payment is due in June, the formulas are putting in automatically, payments that "should" have been paid in May. How do I make it so that the sheet won't calculate until the "entry date"?
-
Merged: API Docs need login?
This discussion has been merged.
-
Merged: Not able to access Smartsheet API Doc getting error
This discussion has been merged.
-
How to make my due date column continuous and with a specific time range in between dates
I am trying to make the due date column so that it enters a date for every 22 days. I want this to be an "endless" column in that it goes all the way down without having to be manually entered. Is there a way to set the due date column to calculate this automatically and fill out all of the rows under it?
-
Put a pause on calculating SLA
Hello, I manage a RAID log for my team. I want to calculate SLA for each issue. I don't want to calculate if the case is checked in IT column and if it's status is "Cancelled", here is my current formula: =IF(AND(Status@row = "Cancelled", IT@row = 1), 0, IF([Closed Date]@row > TODAY(), NETWORKDAYS([Created on]@row,…