-
Page Layout with a table and summaries
Smartsheet often shows a nice calculation at the top of a sheet. Say a list of dealers. The first five lines of the sheet have a nice summary box with the number of dealer in each state calculated or soemthing like that. Now the sheet column headers are really matching the data table not the summary table. So name,…
-
Select RYG color based on other cells
I have a sheet with checkboxes in 3 columns, and I'd like to have an RYG symbol in a separate cell be red if 1 box is checked, yellow if 2 and green if 3. If no boxes are checked I'd like to have no RYG symbol visible. I am assuming this needs to be some combination of IF and COUNTIF, but I have tried different…
-
How to start building project roll-up with 110 dropdown names to pick also
Where to start, project roll-up, don't want a done of linked cells if can avoid it. Need it simple for user interface. Today using Excel just type it in, pick the color for the cell. The color means something based on a key. There is high-level corrdination of the overall program, then high-level for a project, then…
-
Multiple Links to Another Sheet
Hello. I have several sub sheets that feed into a master sheet. In the master, all the tasks and columns of the sub sheets appear. We're having vendors update the sub sheets, and when they do this, their inputs are linked to our internal master sheet. What I want to do is EASILY set up multiple (and numerous) cell links…
-
Using formula to average columns with rating stars
Hi Folks, See my screen shot below. I am trying to get score cell circled in red below to look at the star rating symbols in the child rows and provide the average of the child rows in the score cell. I am assuming that 0 stars equals 0%, 1 star equals 20% etc.......... Help pointing me in the correct direction would be…
-
Calling a client from a sheet
My phone doesn't highlight a phone number for calling from a sheet ....my colleagues i phones do / I'm using a Samsung galaxy note 4 !!! Is it me ...the app... or the phone ???
-
My profile issue
Minor point but have been unable to add a picture to my profile even though it is less than 1024 x 1024 pixels. Does anyone have any thoughts? Mnay thanks.
-
Disabling web forms
Hi, I would like to know if there is a way to deactive a webform automatically on a particular day and time vs. logging in to click the deactive link? Thanks in advance, Kate
-
Is it possible to hyperlink text in a form.
This would allow the user to access additional information when completing the form. I have placed a link to some information in another sheet but the link is long. I know there are applications that shorten urls but I would prefer to hyperlink the text.
-
Date column changing the default behavior of a column
I have a date column called Date of Resolution . I also have a column next to it called Resolved? which is a drop down of either YES or NO. What I want is the Resolved column to automatically fill in from the behavior of the Date of Resolution column. If the Date of Resolution cell is filled in, then Resolved changes to…