-
Pivot App Available for Government Edition/Version
We utilize Smartsheet's to allow for collaboration, reporting, and dashboarding across various entities. It would be useful to allow a pivot app option in the government edition/version to summarize content for managers/stakeholders and would be useful for summarizing data for use in other Smartsheet developed dashboards…
-
What's the best tool to track simple request that comes to our legal office?
I work for a government agency and I'm in charge of tracking questions that come to our office, like what the question is, the topic, who is handling it, date of request and date completed, how much time it took (e.g., 15 minutes or 2 hours). Then maybe create reports on the type of questions that came in, how many request…
-
'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,…
-
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…
-
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…
