-
Recording Clock In and Clock Out
We use a sheet with a form accessed through a QR code to Clock In and Clock Out. The problem is that to figure out the calculation the sheet is downloaded to an Excel spreadsheet and calculated to determine how many hours each person recorded on the time sheet. Is there an add-on or any solution available in smartsheet…
-
Formula to match data from one sheet to another, then calculate the total if a different column true
STUCK in Formula H_ll! lol I'm terrible at formulas and trying to learn! I need your help PLEASE! I have a Master sheet where everyone places orders, it contains the an account number to be charged to and total for each order as well as the status of each order, in a separate sheet I have all of the account numbers. In the…
-
Group Columns in Grid
Hi! I use a really large grid-style Smartsheet to track all aspects of project development and health. It would be very helpful to have a way of grouping columns. The hierarchy for rows works great, but I think with columns I am just looking for a way to clean up my views. I feel like the best (and only) solution right now…
-
Move Row populating at row 51
Hi All, I am working on a project where I have a form to add rows to a main sheet and then the main sheet copies certain rows to a set of 4 helper sheets. I have set the form to populate from the top of the sheet. When the copy rows automation kicks in the rows copied are sent to row 51 similar to how a form populates if…
-
How to make widget that counts year in date column?
I am making a dashboard, and I would like to make the specific year's number change as I add/ delete sections in my sheet. (right now each number is manually typed from a report I made). I have each item filtered by year, and then each item has its own specific date on the sheet. What formula can I use to do this on a…
-
How to sort data by date?
Hi guys. I'm hoping someone can help me. I emailed support but got no reply! I have a sheet with data on it from the beginning of the year. I recently hit sort by ascending and cant change it back. So instead of my data going from 1st- 31st jan. 1st-28th Feb etc its going 01st jan, 01st feb, 01st march and so on. Any idea…
-
Next Task on a dashboard
I am trying to create the above to appear in a dashboard. I have been able to pull in everything (Except the data bars as it seems that is not part of the conditional formatting) but I am struggling to figure out how do I pull in the next step. It should be the either the task that is in progress or some of the team wants…
-
Pivot Table Summaries Getting #REF Error?
I have a few pivot tables set to update weekly, and seem to be refreshing the actual numbers just fine. However, I have some summary functions set up that have totally stopped working, instead giving a #REF Error: I'm a little surprised, as it worked perfectly (with real cell references, not #REFs) when I originally set it…
-
Add an active link or document to a form
Hi All - I can't seem to find a good process for this: add either a document as an attachment, or an active link, to a form that will be sent out to users (sharepoint, via teams). They would open the document or link, then respond to the questions/etc in the form. The users would not be uploading their own documents. I…
-
How to search cell string for text keyword presence
I'm using Jira Connector, and the Jira Label field in the source Jira project can contain multiple values, which get populated in Smartsheet Label column as comma separated strings for each Jira issue row. I am looking for guidance on how to write a formula to search the cell string for a specific keyword, to take…
