-
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,…
-
Excel Conditional Statement formula alternative for Smartsheet
I'm trying to replicate a nested Excel formula in Smartsheet, ensuring it applies the below criteria accurately. However, when I use the Excel formula in Smartsheet, it applies the 'value if true' condition even if the criteria aren't met. Kindly advise what option do I have. Thanks CRITERIA: This formula checks if any of…
-
Report to Sheet
Example I have 10 sheets for each client and converted those into reports to get the information in one place. Now to feed the details like count/avg/pivot/sum on dashboard I should convert the report to sheet. because cannot reference the report to dashboard directly. Will there be anyway to shift the data from reports to…