-
Contol Center: Program/Workspace Relationship
Hello All, I am working to better understand the Control Center application to help my department use this tool at our University. Any information you can provide regarding my question below is much appreciated. What is the relationship between programs in the control center and workspaces in smartsheet? Can a program…
-
Calendar - How Do I Add Times for start and end of meetings, etc.
I'm new to SS and cannot yet figure out why the calendar doesn't allow me to display start and end times for meetings, etc. Is this possible? If so, where is this done? All I see is date related not time. Thank you!!!
-
Automatic Form Repsonse
Hello, I have a form in which staff submit their mileage journeys. In the smartsheet (not the form) I then have a column which totals all their journey miles to give the total mileage completed and the amount to be paid to them which the person submitting doesn't get to see. Is it possible to set the sheet up so that an…
-
Where do replies to Update Requests to external parties go?
I've sent a series of Update Requests to external emails and I've had about 50% response rate. I have had someone check the validity of the remaining email addresses and we've found several of the email addresses are no longer valid (they don't exist) and several others are issuing Out of Office Notifications. When I have…
-
Compiling Survey Results
Hello All, There's a survey we ask people to fill out so we can better provide services. There are 32 specific locations and a long list of questions. I'd like to compile all of this information into a metrics sheet, and in the end create a dashboard. By some miracle was able to tally how many times the specific location…
-
Copy / Paste to create links
I am trying to copy and paste special/links to copied cells; however the "links to copied cells" radio button is grayed out. What am I doing wrong?
-
IF function with many conditions
I have an internal client who wants to parse a list of 100 different zip codes, and depending on the zip, assign another text field into a different field. In other words, IF zip code = 11733 OR 11725 OR 11890 (and so on) THEN assign to New York. Maybe there is a way other than using IF? Thanks for any help you can…
-
Formulas COUNTIF between to numbers
Hello, I am new to the Community. I am having such trouble with designing a formula that will use two past due days for which to count. Here is what I have for the 30 to 59 days count of past dues. =COUNTIF({Audit CAP Summary Range 1}, ">=30") + COUNTIF({Audit CAP Summary Range 1}, "<= 59") It returns a number but the…
-
Formula assistance, please
Good afternoon, I'm not even sure this can be done, but I'm giving it a shot. The picture below is a snip of the sheet I'm working on. I'm wanting to figure out if there's a formula that will put the data from a single cell on the Sep row to the "Current Month" row - but the catch is that is needs to look for the last…
-
@ mentions not working
I am not receiving @ mention in comments even though my Notifications>Personal Settings are all checked. Other users are receiving them fine. My email appears in the dropdown as sheet collaborator. I am the owner of all the sheets. Anybody have any ideas?
