-
Can I use cell history to calculate how much time has taken between two non-date cell types?
Hello SS Community, I have a sheet that is used by medical professionals. We need to calulate the time between a cell that is filled out when a patient arrives, and one that is filled out when they leave. The cells are text based and not date type, nor are they cells where the user is typing in a time (so I cant simply…
-
Publish Calendar Format - Hyperlinks Lost
Hello, I searched but didn't see an answer to this issue: I maintain a calendar, based off a SmartSheet template, whichI publish to our intranet. In the description field, I would like to include hyperlinks. In grid view, the hyperlinks are active and functional. When I change to calendar view, both for myself or looking…
-
"Send Row" opens Pop Up Window from Sight
Hello, I am trying to manage requests from a customer with my local team of people who work on the requests. I love the comments, attachments, that can be added into a row, and the ability to create a sight with different reports. I have created a web form for my customer to input requests, but I would like a clean way for…
-
Include Cell Data in a reminder
Hi guys Just checking as I dont seem to beable to add cell data within a reminder/email. I.e, say I wanted Row One "Name" to be the name of the recipient in a "Hi [NAME]1, TASK X is now complete." I tried JavaScript way "Hey " + [NAME]1 + "Task X Compelete" but not sure of another method of doing this. If anyone could help…
-
Counting the number of check boxes
Hi Please, can some help I have a sheet that uses check boxes and trying to count the number of boxes in that have been ticked. I am using this formula however it just returns a value of count 0 Any Ideas ="Count: " + COUNTIF(CHILDREN(Sent47:Sent1), 1)
-
Send row without sending all attachments
Is there a way to send a row to a user but only select certain attachments to be sent? It appears to be an all or none situation. thanks, Eric
-
Transferring my personal account to a business account
Hello, We are considering a business account at my company, and until now I have had a personal account (that I use for work). With this transfer, we will buy additional licenses for other people in my office. A couple of questions regarding this: - can I transfer my existing account to the new licenses? I don't want to…
-
Is there any integration between SS and Microsoft Groups
We currently have too many document repositories that we use for project info. We use Microsoft Groups to to collaborate with internal teams for discussions and other info including have a Group email address we use. Does SS integrate at all with MS GROUPS? I know it does with MS TEAMS, but we cannot use TEAMS currently…
-
Maximum Limit - Columns, Rows & Cells
HI there, This is the maximum limits of SmartSheet. - Max rows: 5,000, Max columns: 200, Max cells: 200,000 What if I have a whole excel sheet and need to import into Smartsheet, what to do? regards, t
-
Reports including values that should be excluded
Hi there, I am building a report and when I indicate I want the "What" to include all values below 100%, the report still includes the 100% tasks as well. I have tried to entered the in between 1-99 and 0-99 values too buit it still spits out a report including 100% martked takss. I feel a bit puzzled by this. Can anyone…
