-
Formula for counting Stars across multiple sheets
I am trying to count the Stars that are checked across multiple sheets. I can’t seem to get a formula to work. Would anyone know?
-
Setting Up Rules
Hi I would like to know how to set up a rule where if a certain selection is made from a drop down in a cell that it automatically prompts you to complete a related cell. For example: If a member of my team update the Recruitment Status for a vacant role to show 'Offer Made' I would like a prompt set up to automatically…
-
Formula help for my dashboard
Hi all I have a sheet that I use to track recruitment activities within our team. Each role is assigned to a member of the team and has a recruitment status attached to it. I am trying to pull this information into my dashboard to show how many active roles each team member has on the go. However, I only want to select…
-
Help! I accidently deleted a sheet and need it back!
I accidently deleted a sheet that contains important inormation and I didnt create a backup. Is there anyway to recover my sheet?
-
Automatically Sort Data
Hi, Our team works with a spreadsheet which currently is updated quite often / simultaneously by several users. We have been facing difficulties whenever new information is added, since sorting is not properly adjusted until we manually select sorting, refresh and save the data. Is there a way to automatically sort…
-
Pasting hyperlink cell from Excel no longer working
Until today, we were able to copy a cell from Excel that had a hyperlink, and paste it into a Smartsheet cell and it would maintain the hyperlink. This has stopped working today. It pastes the text, but not the hyperlink, and this is a critical component of our workflow. We use Chrome as our browser and have never had this…
-
Auto populate data in other columns by selecting dropdown value in primary column
I'd like to select an item from the dropdown menu in my primary column, and have the two following columns fill with predetermined information. Example: We have 100 items. When I select one from the dropdown menu in column 1, the following two columns automatically fill in the prices associated with that item. Can this be…
-
"The source data for this chart has changed" - Charts with Zero Values
Hello. I have noticed that charts within a dashboard do not display and throw up a message: "The source data for this chart has changed" when they are pointed at sheets or reports where the value is zero / 0. This is problematic for me since I have created a dashboard for a template set of sheets and reports, and…
-
Reports Not Updating
I'm having issues where my reports are not updating. Is anyone else having the same problem?
-
Email to Smartsheet?
I currently am locked into Outlook 2010 on my PC, but it is connected to Office365. Is there anyway to create a row in a sheet when i flag or categorize an email OR can i forward an email into smartsheet somehow? EDIT: I am open to using Zapier or IFTTT also. Thanks.
