-
Include Help Text on Form Submission Copy
My organization currently has a site visit assessment form. Many questions on this form are too long for the sheet column headers, so the columns are just labeled Question 1, Question 2, etc. The actual question is then put in the "Help Text" field on the form. Many leaders who fill out this form opt to receive a copy of…
-
Level a resource in a Sheet?
I've imported a project into a project sheet and now would like to level the resources that are overallocated so the schedule adjusts to show the actual schedule if I use these resources. Is there a way to do this? Thanks in advance, Sue
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Linking restored files back to existing reports
I have a summary report that collates updates on all my team's projects. Earlier this week a colleague accidentally deleted one of the project sheets. The sheet has now been restored and the owner has confirmed everything's working as it should. However I now can't link it back to my report…?! When I look at the sheets to…
-
Move Rows Automation Suddenly Failing - Multiple Sheets
Hi. I manage 3 very similar smartsheet tools for 3 different office's training request intake and approval systems. Once requests are approved, an automation has successfully been moving them to each site's Request Archive Sheet. This has worked as expected since March. For some reason today this feature has suddenly and…
-
how to combine multi formula conditions
Hi team, Trying to create a vehicle luggage capacity calculator for small and large cars, Please find below, Please find the below Formula: =IF(AND(Passengers@row <= 4, [25 Kg]@row <= 2, [15 Kg]@row <= 1, [7 Kg]@row <= 1), "Yes", "No") The formula above indicates the col [Result] is "Yes" in the ase of follows: The number…
-
Manual Copy and Paste of rows fails to paste formulas and hierarchy
About 3 weeks ago I began being unable to copy and paste multiple rows between sheets in smartsheet. I have about 12 rows with several columns that match columns in a separate sheet. I am trying to copy rows from one sheet manually using CMD+C and CMD+V (I am on a mac) and paste them into the new sheet. I am able to select…
-
Cross checking grids
Any help is appreciated. Also, if anyone can recommend which training/certification class would be better to deep dive into the formulas and workfflows for these types of specific tasks, I would love the recommendation. I have Registration forms for 2 separate trainings (Training 1 Registration) and (Training 2…
-
Formula to use in the summary field for the number of rows within a specific column
For example: If the column is about colors, I want a formula to see how many people chose red or how many people chose green in the survey. And I want this formula to put into the summary field so that I can upload into my summary report and into a chart in dashboard.
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
