-
'Save' button for work in progress, for external form-fillers?
We use Smartsheet forms for grant applicants to submit initial information. Without a 'save' button or feature, we've had to advise our applicants to prepare all their answers offline, and then enter all their responses in one session. This can be problematic if the applicant gets pulled away on another task, call, e-mail,…
-
Hide comments in a published report?
Hi there, Is it possible to hide comments in a published report? I see this is an option when publishing a sheet as "Read only - HTML", but this option does not appear to be available when publishing a report. There are comments in our main sheet that the report is built on which we do not want to be visible in the…
-
Reporting Earned Value vs Planned Value for SPI Metrics
Good afternoon everyone, I'm new to the SmartSheet community, but my company and I have been integrating SS into our PM work processes for about 1.5 years. We're a VOSB DOD contractor, and we use SS to create simple project schedules that include start/end dates, duration, dependencies, and % complete. We do not resource…
-
Form Options - Automation
Good morning, I'm trying to create a form in for entering and/or removing equipment from our site. There are times we have new equipment installed where equipment is not removed, and vice versa, but also times where both apply. Essentially, our wish is that the contractor would complete the form and if they check a box…
-
Using nested MATCH/INDEX across multiple columns
Hi, I'm using two sheets to track the distribution of transportation gift cards, one will be a master list of the cards and the other is a webform tracker that distribution partners use to log who receives cards. I want the master list to check off each card given out after it is logged into the tracker, however each…
-
Is it possible to create a workflow to transfer indented rows to a separate sheet?
Is there any way for the workflow to trigger and move the indented row independently from their parent row to a separate mirrored sheet (exact same set up)? My specific scenario: Tracking form numbers that fall under different categories (series/subseries). The forms are indented to be nested under their respective series…
-
Counting number of times Name appears in multiple contact column
I have a column set up as a multiple contact to capture all authors on a journal publication. I would like to use a formula that will count the total number of times a specific name appears in then column. I have tried =COUNTIF({ALL AUTHORS},"John Doe"), but I know it does not yield all of the times the name appears. I…
-
Extract Cell History For Formulas
Hello, Is there any way to extract the Cell history to calculate formulas. What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time…
-
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.…
-
Networkdays/Workdays Excluding Holidays and Exceptions
Hello, I am having multiple issues with my calculations for NETWORKDAYS and WORKDAYS working in Smartsheets. I entered default holidays into the Non-Working Days (holiday, exceptions) box in the Account Administration field assuming that once I set up the holiday/exception dates Smartsheet would deduct these dates from the…