-
Formula for sum of values in columns of other sheets per collaborator. Cells assigned to "nn".
I have a summary sheet "Summary Sales" created from another sheet "ADMIN_2020" in rows 2, 3 and 4 of the "Summary Sales" I have 3 employees assigned. And I need to do the sum of the entire column (NETO column) from ADMIN_2020 for each independent contributor. Who can help me will be very grateful. regards
-
Update requests are not being received by team members
Update requests are not being received by team members who do not have full licenses. Do I need to let help desk know specific servers to whitelist?
-
How to save a formular if i export the table to an excel file?
Is there a way how to save or export a formular, so that i can reimport the (excel) file for an oncomming use?
-
Using Employee Directory template
While using the Employee Directory template embedded in a website, is there a way for this information to be displayed in a way other than forcing a user to scroll through an entire list? For example, is a user able to type in a name and be taken to a smaller list based on their input? Also, can the list be limited and…
-
Smartsheet forms
Hi, On a daily basis I fill a Smartsheet form, i.e. load 10+ entries at a time. Is there a way to raise several entries using the form in a batch, to save keep repeating the same standard information (name, email, etc.)?
-
TRYING TO RETURN THE DAY OF THE WEEK.
trying to get the Day of the week (ie. Mon, Tue, Wed) to return based on a date column. Tried this, but getting and unparseable error - what am I missing? =IF(WEEKDAY[Bid Date] = 1, "SUN", IF(WEEKDAY[Bid Date] = 2, "MON", IF(WEEKDAY[Bid Date] = 3, "TUES", IF(WEEKDAY[Bid Date] = 4, "WED", IF(WEEKDAY[Bid Date] = 5, "THU",…
-
Having problems embedding Smartsheet into new Google Sites
Hello, I am not able to add my DevOps course list attendees embed with a Smartsheet into the new Google Sites. I can easily embed other sites like soundcloud (works rather well). Please help - thanks.
-
Losing data when multiple users making changes at the same time
Hello, I am having the exact same issue as Thor did in 2015 - https://community.smartsheet.com/discussion/385/losing-data-2 I sent out a current user view report to my project managers and when they all update their individual rows/reports respectively, I keep losing the data in my cells. How do I ensure to get their…
-
Issue: incorrect numbering of attachment versions
I faced this issue when three and more files are attached to the row. In this case, their numbering becomes incorrect. For example, the latest version of the file can be marked as V2 or V3 whereas it should be V4 (in case if four versions of a file are uploaded). This causes a mess and the only way out I see so far is to…
-
Best way to automate sending a row attachment to an outside client?
For each job my business completes, we record the job and all information in a single row. Once the job is complete a report is generated with Smartsheet merge in Google Docs and saved to the specific row for the job which also includes the client's contact email. Regardless of how the attachment arrives at the sheet row,…
