-
Unable to get SUMIFS to work
Hello, I am trying to use the SUMIFS function to total up the expenditure data from an imported file. I want the cell to total all of the expenditures for a particular district based on fund type, but am not successful. I am wanting to pull the data from another sheet called "Allocations" which has all of the information I…
-
Consolidate rows by assigned to - Automated workflow
Is there a way to consolidate rows by 'Assigned To' in automated workflow so the user is only getting one Smartsheet notification with the rows assigned to them? For example: I want to send a consolidated list of all late start tasks that are assigned to "John Smith" in one notification vs. that person getting an email for…
-
Symbol formulas
I want to compare 2 cells and depending on the results, display a different symbols. I have a column called Average Time. There are 2 cells, one for Q2 and one for Q3. If the average time in Q2 is less than Q3 I want to display an Up arrow, if it is the same a Dash and if it is greater, the Down arrow. Thanks in advance…
-
A Beginner's question coming from a self-taught 4+ year Smartsheet user...
Apologies for the basic nature of this question. I am a Director of a NP that sends disadvantaged kids to sleep-away camps. I have three main areas of concentration: 1. The Camps (who offer the scholarships), 2. Our Educators (who select the camper), and 3. Our campers. Each of the three concentrations are populated with…
-
Current User Views on Reports/Dashboards
Hello! I am trying to create a dashboard for internal, unlicensed users to see tasks assigned to them, and I seem to be missing something because I can't get it to work. I have a report filtered to current user: I have the report on the dashboard set up to show the viewer's data: I have the user shared as admin to the…
-
Data entry in Smartsheet->Invoice generation->Send to client->Sign->Attach signed invoice to row
Currently we use the Google Doc integration to produce an invoice pulling the data from a selected row in Smartsheet. This gives us a pdf, which we then manually deliver to the client, get signed, then scan and upload. We would like to change to an e-signature. Adobe can do it, but we would need to export our file to…
-
Reminder email font issue
Good morning, Since the recent changes in the layout of reminder emails, I've noticed that the font for the text box field comes through very small. On my end, it looks like it's around a 6pt Arial. Is there a way to change it to a larger font? I've included a photo for reference.
-
Can data received from a form be sent to different sheets?
Hi everyone, I find Forms is a great feature to gather consistent data and then take actions. I wonder if there is a possibility that we can send data received from a form to different sheet? Now I think it is only possible for one source sheet. Many thanks, Dat
-
Print table into template
I'm looking for a way where I can export a table from Smartsheet into a pre-set titleblock. If there's a way where I can print directly from Smartsheet and have the titleblock set up so it prints with the table, instead of just the logo and title that it's currently offered in the printing window.
-
Help Needed
Hello, All. I need to create a formula where I am summing particular values in the same column wherever that value appears. For example, if 1 appears 5 times in the column, I wish the formula to return 5. However, I also wish this formula to sum up 2 other values in the column if they appear (column value equals that…
