-
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…
-
Edited CONTACTS - flowing to other sheets
If I edit a contact in My Contacts (the Name portion, not the email), will that flow to everywhere the contact is used (all sheets)? It appears the answer is no, and it takes manually editing each instance of the contant on all individual sheets. Hoping this is not the case, or there's an easy solution or workaround.…
-
Nested IF AND with Multiple logics - Not bringing the expected outcome
I am trying to write the following logic to calculate the SLA breach. LOW - Greater than - 7 days MEDIUM - Greater than - 4 days HIGH - Greater than - 2 days CRITICAL - Greater than - 1 day. However, the formula is not accurately bringing the breach/no breach as expected. Except "Critical" all of the other severity logics…