-
Sheet exceeded the maximum recommended size
Has anyone received this error message before? What are the options for large data?
-
Automation - triggered within a set number of days before a date
Hi everyone! I need to set up an automation that is triggered within a set number of days before the date listed in a date field. I need the automation to send an alert email to a new hire at most 7 days before the start date. I know I can set the automation to send 1 week before the start date, but if the new hire's…
-
Average by section within a column
I am working on a sheet where we are tracking the percent complete within a column. The top percent complete formula is =AVG([Percent Complete]2, [Percent Complete]17). The formula in [Percent Complete]2 is =IF(Completed@row = "Completed", "100%", COUNTIF(Completed3:Completed16, "Completed") / 14) The purpose of the…
-
How do I get the exact number of Years based on the date column (no more rounding up)?
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…
-
Interactive Graphics
Here is my goal: I need to create an image where the image has multiple areas. If one clicks on the that are (much like an image map in HTML). Then I need a secondary window to open where the use would select the status on that area. In Progress, not Started, Complete. But also I need it to show the last note added to that…
-
Help!
I have a vision i know what I want but I cant seem to figure out how to do it. Anybody up for a zoom or teams call to help me?
-
Reporting by month
Hello! I'm creating a reporting dashboard from a Smartsheet that tracks all incoming project types and I'm hoping to report a breakdown of the number of projects that are due each month. Is this possible with a particular formula? I'm coming up with a lot of errors. Thank you!
-
[Critical Error] Owner of the sheet can't edit despite having a Business Plan Member seat
Hi, I’m the Owner of several sheets, but I’m currently being treated as a "Viewer" and cannot edit anything. The Issue: Even though my Seat type is correctly set to "Member (Paid)" (as shown in the attached screenshot), I have no editing rights. System Error: On the User Management page, multiple error messages saying "We…
-
Free Functional Specification Templates: The Roadmap to a Smoother Development Experience
Hi. I am a new user. The Smartsheet website proclaims it has templates for functional software specifications. I can't find anything. I also can't find any resources or training videos on the smartsheet.com website or youtube on how to use smartsheet for capturing user stories and requirements. Can anyone help me out here?
-
starting out
I have no idea how to start the program. I need the basics on how to build charts and graphs.