-
Claims Denial Management
Hello. I will be working on building out a claims denial management work plan but was wondering if one already existed within the abundance of templates?
-
Countifs using iferror or iserror
Hello, I'm trying to use a COUNTIFS formula to count the number of VLOOKUP errors in another sheet that occur in the past month. From what I can see in other discussions the IFERROR and ISERROR functions are generally used to give a 0 value but I want it to return a value of 1 for each error. This is the formula I've been…
-
Budget Sheet YTD Sum formula help
I'm building a sheet for a department who wants to track monthly revenue/expenses and have those numbers roll into YTD columns. (moving them into Smartsheets and out of Excel) Each month has 2 columns Actual & Budget, i want to set up a formula so when numbers are entered into respective monthly cells the YTD cell…
-
How to track items that are completed after their due date
Hello! I'm trying to track tasks that are completed after the due date. I used this formula to indicate when an task was past due and not complete but once the task is checked off as complete it no longer works, well it works it just doesn't give me the data I'm looking for. =IF(AND(TODAY() = DUE5 + 1, Done5 = 0), 1, 0)…
-
smartsheet API
Greetings Can someone please explain to me how APIs work ? I am not familiar with many of the technical jargons used on the SMARTSHEET API link. I need to update data on my Gantt charts automaticallu instead of manually inputting the numbers and dates. Can APIs be of any help to carry them out ? Can I somehow read and…
-
RACI Matrix
Hi I am looking for a good RACI matrix that tracks the same way an issues and actions list works. I want to combine the two sheets into one tracking sheet and shows the RACI matrix for each issue/action. Does anyone have any good templates I can use as a boilerplate maybe? Thanks my email is constance.wade@allscripts.com
-
applying vacation or unavailable time to resources
Hello, I am an MS project user and in that program you could denote unavailable time for resources so when a task assigned to that person fell on an unavailable time period, the start and end dates accomodated for that automatically. Is there a way to do that in SS? thank you, Karen
-
Interactive Room Map
Hi all i have a room full of storage freezers. Within each freezer there are 4 shelves of four stainless steel containers. Each container contains 32 positions and each position is a project. is it possible to start with an interactive “map” of the room, where I can click on any freezer, select a shelf then a container and…
-
IF statement with flag symbol
Per the attached screen shot. How would the formula be written so that the row2 flag turns red IF any of the flags(row3-row11) are toggled to red? Thanks
-
Select multiples in either a drop down or check box on a form?
I am working on a customer survey (form) and would like the customer to be able select multiple items in a drop down or have multiple check boxes available in a single column? Is this possible now? Is this in development? I know there a couple of ways to work around this but nothing very elegant comes to mind. It's…