-
Burn down
Hello, i would like to assign cost rates to different people and to auto calculate the burn rate for my projects. this information cannot be shared with the people that the prject are shared with. Is there a way to do this? thanks, kate
-
Create a new report/ count toward sheet limit?
Whenever I create a new report, does the report count against my sheet limit?
-
Resource management for contacts, not users
We have a joinery shop that we use smartsheet for each project. I have users/workers who do not need access to smartsheet, but I want to enter them in as a contact, to be able to allocate jobs to. I cant add them as a user, because they do not have work emails and I will not be sending the smartsheet emails to their…
-
Bump of old question - User input for reporting
Original Question: "https://community.smartsheet.com/discussion/use-web-form-return-row-or-report-another-sheet#comment-6824" essentially, I would like to have people with shared access be able to enter in a search term or term and then run a report off of that. The only way I see to do something like that is to re-run the…
-
Reporting not working
Reporting is still not working. The Smart Sheet Status page shows it is working properly, however, I cannot run reports.
-
Use web form to return row or report from another sheet?
I have a sheet with 2500+ rows of data + attachments. I would like to allow a technical group the ability to complete the web form with some criteria and return the rows that have the specific value in it. Ideally this would be a nice report nicluding any attachments. Can this be done? The other option is to give access to…
-
Combining Formulas
I am currently using 2 columns to identify tasks "Due in Next 2 Days" and "Past Due/No Schedule". I have been trying to nest the two formulas together to get the status in the same column. How can the following formulas be combined togateher: =IF(AND(Due6 <= TODAY() + 2, NOT(Due6 < TODAY()), NOT(Status6 = "Completed")),…
-
Sorting from a drop down list that parallels parent row hierarchy?
I use the sales pipeline by stage sheet and love it. Typically, we manually move rows between our stages, which are set up as parent rows. I use the stage as the parent so I can easily keep track of my totals, which gives me trigger points for action on issues when sales may get slow. I also derive all of our sales…
-
Remove user but retain resource management functionality
What is the suggested/best practice for removing/revoking a user's access to a team account and it's sheets, but to retain the historical data for that user in resource views and reporting? I am trying to remove former employees' access/ability to see our team data, but I don't want to lose them from resource management…
-
Report Request: Show new discussions added within a time period
I would like to be able to publish any rows that have recieved new comments over the past 7 days along with what those comments are. Is that possible?