Guys! The smartest people I know! Does anyone have recommendations or best practices to do or do not do related to sharing materials with customers. We currently share a Workapp with implementation cu…
I need a Date (the Actual End Date) in the Description Column Row 35.when the Task cell equals the task of current row. and if no date in that cell to be blank Current formula is =IFERROR(DATEONLY(IND…
I think I may have a good use case for using Dynamic View, but need help. So I have a sheet that basically is managing the status and progression of a customer request that my staff completes and noti…
# of Contracted eDocs - # of Submitted eDocs = Need Contracting; IF the number is less than 0, I do not want a number to display in the Need Contracting field unless it is negative.
I need a formula for column "Days to Build" I want the number of days it has taken to build using Build End Date - Build Start Date = Days to Build, but if there is no Build end date I want it to be t…
I have sheet that has a hyperlink using the "link to other smartsheet" function and the sheet linked is contained in the same workspace as the sheet where the hyperlink is. But when i set up the worka…
I want to calculate the Days to Build field by counting the number of days from the Ready for Customer QA minus the Build Start Date. And if there is no date in Ready for Customer QA I want to know ho…
If ANY cells in Status3- Status7 = In Progress then I want Status2 to equal "In Progress, If ALL cells in Status3-Status7 = Complete then I want status2 to equal "Complete" @Paul Newcome @Andrée Starå
Currently using the Onboarding Template Set and in the Sheet Onboarding timeline, I have the Risk flag set, the current formula is to flag if the end date is in the past and the status is not compete …