-
newbie questions
I would like to create a worksheet which tracks our purchasing and the vendor I source from. and it the same sheet have another tab which have the vendor contact information. When I double click on vendor in the master tab it will help pull up the vendor contact details that is on another tab. Is that possible? Does…
-
Personalized user authorization for one cell, and date recording
Hi all, I have a couple questions for all the Smartsheet pros out there! I'm working on a sheet and I would like my team members to be able to update its content. The first problem is that I would like them to be able to edit only some columns and rows, depending on their responsabilities in the project. I mean that each…
-
Changing Parent to red, yellow, green based on child
Hi, I'm trying to create a status report that will change the parent status to "Red" if one of the children are in "red", or yellow if the child milestone is in Yellow. These are milestones, so there should rarely be a red milestone and a yellow milestone at the same time, unless we're really off track. Can anyone help?…
-
Sum using symbols
Can I sum the columns where I used a symbol to show the value? for example - if I use the Stars Symbol for 'Size of effort' - Empty stars = 0, 1 Star = 1... and the Faces for 'level of urgency' - No Pain = 0; to Extreme Pain = 5 the total Size + Urgency should be ~ 1 star + Extreme pain = 6 If I use the basic sum formula…
-
Can I view history of who set/removed alerts and when?
An alert was removed and we do not know how that happened. Has anyone else had this experience? Is there an alert history we can review? Thanks! Sheila
-
Date Formula dependent on text
Hi All, I am looking for a formula that can ideftify text in a column and convert it to dates. More specifically I need it to pick up a cell says "X" convert to today's date +30 days, or if it says "Y" convert to today's date +30? I have found a formula that works in identifying only one set of text: =IF([Project Name]34 =…
-
Working examples of Smartsheet in Order Management & Production environment
Hi There: I'm implementing Smartsheet across a client's furniture manufacturing environment. I'm new to SS but have been diving in deep since the beginning of the year. However, I'm still struggling with particular case use with respect to managing the workflow between different departments involving both physical and…
-
Additional Duration Options
It would be very helpful to have duration codes to have the duration snap to, say, “Finish next Thursday,” or “Start 5 Fridays from Finish.” These durations might look something like “F1Th” or “S5F”. Naturally, the “Start X Fridays from Finish” type of duration only applies to certain predecessors styles, such as…
-
Excel Compatible Symbols
Hi there, I am creating a sheet for a project that I will need to export to Excel for poeple outside of my company to use and I was wondering if there are any symbols that are compatible with an export to Excel ie. would look the same. Thanks in advance, Graham
-
Can it be possible to set up a button to refresh a sheet with the information coming from other port
Hi Team, Can it be possible to semi automate data refresh using an explicit button. On a sheet rules/functions are written to extract the information from other sheets, I would like to place a button on this sheet with the intention for the user to refresh the page to see the latest information.
