-
How to apply same color to the objects in Calendar view as that of Gantt
Hi, I have created a smartsheet in Gantt view and given different colors to different lines. But when viewed the same smartsheet in Calendar view, I don't see those colors. Is there a way the colors I used in Gantt view are reflected in Calendar view?
-
If/And Formula Question
I need to write a formula that allows me to dictate that two conditions on a single cell are met and one condition on an additional cell is met. The formula will be if the start date is not blank and is less than today and the status column is blank then the flag is checked. I am unsure as to how to write the syntax for…
-
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
