-
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…
-
Formula to pull the Fiscal Year from a Launch date
Hello! I'm looking to pull the Fiscal Year in a cell based on the launch date in a different cell. Our FY starts on 04/01 of the current and ends on 03/31 of the following year. I need the formula to determine if the FY is the current year, the prior year, or the next year based on the launch date. For example, 04/25/2024…
-
How to unsubscribe or delete my account
I no longer use smartform in my business, so could you tell me how to Unsubscribe or delete my account?
-
Index/Collect with Specific Criteria
I am trying to automatically populate the Parent "Content Development Status" column based on the most recent "Child" in the "Tasks" column, but there are certain Children rows in the Task column that I want to ignore. For example, if there is a webinar delivered, I do not want this to populate in the Content Development…
-
Using Reference Sheet to toggle Checkbox
Hello, I've been digging and digging through Smartsheet posts and other references and cannot seem to find a comparable reference to use for my use case. I have 2 sheets. The first sheet stores PMs for equipment inspections. There is a column for "Equipment Name" and a column "PM Date". The second sheet has a column for…
-
Nonsense letters - Mapping PDF doesn't pull information from form/sheet correctly
I am trying to use the entries from a form to auto-generate certificates of completion. It seems I have everything set up correctly (Fillable PDF mapped, set up in the workflow, correct column naming etc), however it generates nonsense letters for the entries. Any ideas on what I should troubleshoot to fix this?