Hello, I'm assisting some colleagues with a solution that helps track music session bookings. There are a number of summary reports set up, which the metrics are then displayed on a dashboard. It's be…
It would be great to be able to replace my full user name (which is kind of long) with initials when displaying on the sheet. Using the "latest comment" column, my name takes up a a lot of screen spac…
Hi, How can I allocate the resources in single task when I have multiple task owners or multiple Task managers? * How can i allocate the hours based on individual manager? Best Regards Saqib
I'm trying to figure out a way to sum the amount column using only distinct clients and amounts that are tied to duplicates once. for the sake of the example let's say this is my data, the actual file…
I want to remove the subjectivity in reporting on project domains. The aim is to use a formula to determine the 'summary rating' of a domain eg risk. This will be based on the content of the risk log …
In Excel I can create sheets within a workbook- is this a possibility in Smartsheet where I can create a sheet within an existing sheet so I can have another Tab with Data?
I'm using this in a metric sheet to count the term in a sheet that has multiple entries per row from a drop down list. It currently produces the error message #INVALID OPERATION. =COUNTIF({PH Roadmap …
I have a sheet with a list of courses to develop each term. Each row represents a course and modality (online OR blended). In most cases, only one modality is developed for each course. In some situat…
I have a sheet where I need to have a notification sent to a team every 6 months from an entered Start Date. On my sheet, I have the Project Name, the Project Status, and the Project Start Date. It se…