-
Help with PDF Fillable Files on smartsheet app
I have salesman that use pdf fillable forms for company use. I created a sheet that has all the forms in it as attachments. When using the desktop version they click on the attachment and it brings up the file and they file in the information and can print it. They are unable to do this in there smartsheet app for IOS. I…
-
Conditional Formatting with multi select dropdown list
When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,. What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condition one' or 'condition two' then apply this format to the column one Is there a way to…
-
Formula to calculate the amount of "done" rows for different years.
We do a lot of service jobs that we use smartsheet for. When its done they mark status as "Done". I know I can find the total amount of done rows by: =COUNTIF(Status:Status; "Done"). But how do I make the formula filter for jobs done in 2018 or 2019 etc? Kind Regards, Hugo Martinwall
-
Scheduling by Skillset
Hello! I am wondering if you can set scheduling on Smartsheet, and if you can, a program on Smartsheet for scheduling based on employee skill sets on Smartsheet. If there is, how would I go about doing that, and what ways can we incorporate those skillsets for each employee under a saved file that can be easily edited as…
-
Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…
-
Filtering/Slicing in Dashbaords
Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter/slice the data in the dashboard view, say to specific users or anything like that (for example, I can see total sales…
-
Send Row function not working
I understand on 9/19/2019 Smartsheet changed unlicensed user functionality. The send row function is now no longer working for a two users I share a sheet with. The function is grayed out and returns a message to upgrade to a paid level. They cannot cannot perform their job duties without this function. The UNM HSC should…
-
If criteria is xxx, duration is zero
Dear Smartsheet community, I have a sheet for staff to report time off. I have this formula to calculate the net working day(s) between begin date and end date. =NETWORKDAY([Begin Date]@row, [End Date]@row) However there will be occasion when staff will not be taken time off. Therefore, I want to add where column Absence…
-
Ultipro to Smartsheet
I'm pretty new to Smartsheet and trying to figure out a new workflow. Currently all new job postings and job applications are captured in Ultipro. There is currently no integration between Ultipro and Smartsheet, what would my options be to move candidate data from Ultipro to Smartsheet so I can start building a candidate…
-
Copy of my responses
I'm not sure if this was already addressed in a previous post or not so I appreciate your patience. I created a registration form that has 6 choices for respondents to choose from. Is there a way to format the "copy of my response" email to only include the specific choice they picked? Currently, the email includes all 6…
